blank spaces is inserted when i insert values to columns

[bereza]

Hi everybody

I am using SQL Server 2005, it is first time, before it was just sql 2000.



I have created a little table that contains columns which are nvarchar(50). when I insert into the table (by opening it and write by hand or by using sp), if my string is less than 50 charactars it inserts blank spaces in the end of the string.



Why and how can i have strings without blank spaces.



thanks

 

[SQLSister]

It shouldn't do that with an nvarchar field. Are you sure it isn't nchar which would do that?

Please post the code you use to insert data if that doesn't turn out to be the problem.

"NOTHING is more important in a database than integrity." ESquared

 

[bereza]

thanks,

yes thay are nvarchar and i use following in a sp to insert values.

insert into MyTable Values('GroupName', 'UserName', 'EMail', 'FullName')

thank again

 

[jbenson001]

if my string is less than 50 charactars it inserts blank spaces in the end of the string.

How are viewing the data that shows the spaces?