In SQL Server 6.5, two status bits have been added to the status column in syscolumns.
New status bits | Description |
---|---|
16 | Indicates ANSI_PADDING was in affect when a varchar or a varbinary column was created. Indicates that trailing blanks are preserved when varchar data is updated or inserted; and that trailing zeroes are preserved when varbinary data is updated or inserted. |
32 | Indicates that a varchar or a varbinary column is a fixed-length datatype that accepts NULLS. varchar data is padded with blanks to the maximum length and varbinary data is padded with zeroes. |