move from MSS sql server 6.5 to ODBC driver

[mouniryoussef]

i m moving from MSS driver to ODBC driver and
I m noticing that when I select a text field it gives me spaces after the text

any idea ?

thanks a lot
Mounir

 

[mouniryoussef]

for more infos i found that :
In MSS, you can specify that the DB truncate trailing spaces. See
ANSI_PADDING. This really becomes a nuisance when either performing string
comparisons (pre-MSS 2000) or concatenating strings (e.g. "Dale " +
"Fox
" becomes "Dale Fox " instead of "Dale Fox").

mounir