AnsiPaddingStatus Property
This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.
The AnsiPaddingStatus property returns TRUE if the referenced column is defined to exhibit SQL-92 character padding behavior.
Syntax
object
.AnsiPaddingStatus
Parts
- object
An 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 trailing blanks and null bytes are not trimmed as data is inserted.