When I enter a data in a table, SQL Server automatically completes the data with blanks up to length of column.
this happens in a web form also in Management Studi?o,
Whan am I doing wrong ?
does Collation have anything with it ?
SQL Server 2005 / Developer Edition
It sounds like you are using the char data type. SQL Server will automatically pad this with spaces as it is a fixed number characters. Use varchar instead.|||
thanks for your help,
now it is not padding.
No comments:
Post a Comment