Monday, March 19, 2012

Changed from char to varchar

i changed my state table from char 20 to varchar 20 and it still fills it with empty space at the end of the statename
I tried entering it with the trim command still no good
i looked a the sql command made in vs and it says that the variables are varchar
is there something i am missing with varchar
does it only work properly if it is over 50 or does it not change completely when you change from char to varcharIt shouldn't be padding the fields if using varchar. Your existng values would have to be trimmed. I don't think changing the datatype would automatically do that for you.

Check the ANSI_PADDING database option, also.|||alright i will look into it

No comments:

Post a Comment