ADO.NET Whitespace padding problem

Answer 1

Try NVARCHAR instead of NCHAR.

Answer 2

You're using an nchar(255), which is a static length of 255. Try changing the column to nvarchar(255).

An nchar(255) will always give you 255 characters. Those that aren't used are filled in by whitespace (0x20 in ASCII aka a space). nvarchar(255) will allocate 255 characters when initialized, but only use the characters necessary.

In this case, you want nvarchar(255), since you have a variable-length string.

Answer 3

NCHAR is a fixed length field. Using NVARCHAR as your data type would keep you from getting the spaces.

Answer 4

Use nvarchar instead of fixed length field type.