Variable-length, non-Unicode string data. n defines the string length
and can be a value from 1 through 8,000. max indicates that the
maximum storage size is 2^31-1 bytes (2 GB). The storage size is the
actual length of the data entered + 2 bytes. The ISO synonyms for
varchar are char varying or character varying.

You mean that the added whitespace is normal and it happens all time (I mean to fixed-length chars ?) ? And trimming the value to the end is what people normally do ?
–
AshkanSep 24 '12 at 16:51

1

char will always pad the data to be the fixed length you specified when creating the column. You would not normally use char if your data is not fixed-length, because of the hassle you are experiencing right now, anmong other things :)
–
RedFilterSep 24 '12 at 17:07

Thnks alot ;) I`m gonna have to be reconsidering using fixed-length columns for that manner .
–
AshkanSep 24 '12 at 17:24

what people normally do is not use char unless they have a fixed length type of field (say 2 duigit state codes). VArchar is generally teh preferred choic fora field with variable length data.
–
HLGEMSep 24 '12 at 18:40