Hello,
We switched fromÃÂ SQL Server 2005 toÃÂ SQL Server 2008 and came acrossÃÂ an issue with trailing spaces being preserved when we select CHAR value.
For example, I have a CHAR(30) column withÃÂ value 'abcd'. When i run application with SQL2005, the value that comes back is 'abcd'. In SQL2008 it's 'abcdÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ ÃÂ '.
ANSI_PADDING is OFF on both DBs.
Any other settings that force SQL server trim the trailing spaces?ÃÂ
I read about REPLACE change, it says thatÃÂ in SQL Server 2008, trailing spaces specified in the first input parameter are always preserved. Is this change applicable all across SQL2008?
Any pointers?
Thank you.
Isolda
View Complete Post