Insertion of blank caracs in each rows.
Posted on 1998-11-19
I DO am a novice user of SQLServer 6.5 and 7.0 beta3
and I have a problem in my DB that is the following:
MSSQL automatically inserts white spaces at the end of each
new slot in any inserted row so that the size of each string in the row is maximal.
For instance, if I create a table with a column of type
VARCHAR(5) and I insert a row containing the string "toto", the table will contain a row with the string
equaling "toto ".
The strange thing is that it does not happend systematically!
If I drop the table and fill it several times, I do not
get the same problem again, but new rows inserted
afterwards are still affected...
This should not be coming from my stored procedures as long
as I haven't got any pb on another DB...
Is there a problem with my SQLServer configuration?