visual studio sql DB adds whitespaces

Question

I'm working with VS2010 and asp.net and build a SQL Server Database with some int and char values.

My problem is, that the char(50) automatically fills the unused chars with whitespaces like:

"foo           "

What can i do to get only "foo"?

Yes, that's the way CHAR(x) is defined in SQL Server - use VARCHAR instead if you want to have string only as long as needed. See the SQL Server Books Online documentation: msdn.microsoft.com/en-us/library/ms176089.aspx — marc_s
– marc_s, Commented Aug 9, 2010 at 16:26

Jeff Mattfield · Accepted Answer · 2010-08-09 15:38:10Z

7

Change it to varchar(50). The char(50) data type will fill the remaining characters of the field with spaces.

answered Aug 9, 2010 at 15:38

Jeff Mattfield

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

Comments

LittleBobbyTables - Au Revoir · Accepted Answer · 2010-08-09 15:41:08Z

2

It's not Visual Studio that's adding the white spaces, but your datatype.

Char is fixed-length, while varchar is variable length. Char will pad the remaining text with spaces up to your field length.

You can see more information about SQL datatypes here.

answered Aug 9, 2010 at 15:41

33k25 gold badges113 silver badges115 bronze badges