SQL Server Management Studio is filling columns with spaces

Question

I'm using SQL Server Management Studio to manage my database.

The problem is that if I have a nchar(50) column in a table and I insert a value of test, what I will find in my table is this value

test<46spaces>

These spaces are making so much trouble for me. How can I stop this strange action?

Thank you

James Z · Accepted Answer · 2015-11-28 15:29:55Z

3

The reason is you're using char / nchar which are fixed length strings. Change your datatype to nvarchar.

answered Nov 28, 2015 at 15:29

James Z

12.3k10 gold badges27 silver badges48 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Thank you, it was that simple! :p