Set ANSI_PADDINGgreenspun.com : LUSENET : SQL Server Database Administration : One Thread
We are using OLEDB to connect to SQL 7.0 and we are having problem with columns of CHAR data types. It returns spaces with full length of the columnc. e.g if column is char(5) and it has value "A" the return values are "A ". What are the work arounds to avoid this problems we tried using Set ANSI_PADDING ON/OFF while connecting using OLEDB but but it does not seems to make any difference ?
Any suggestions ?
Kamal Hassan (905) 790-2800 ext. 4849
-- Anonymous, August 21, 2001
One work around is to change the datatype to varchar.
Hope this helps,
-- Anonymous, August 22, 2001