AnsiPaddingStatus Property
The AnsiPaddingStatus property returns TRUE if the referenced column is defined to exhibit SQL-92 character padding behavior.
Applies To
Column Object |
Syntax
object.AnsiPaddingStatus
Parts
object
Expression that evaluates to an object in the Applies To list
Data Type
Boolean
Modifiable
Read-only
Prototype (C/C++)
HRESULT GetAnsiPaddingStatus(LPBOOL pRetVal);
Remarks
By default, Microsoft® SQL Server™ trims trailing blanks, or null bytes, from variable length character or binary column data when values are inserted. The SQL-92 standard requires that trailing blanks and null bytes are not trimmed as data is inserted.