AnsiPaddingStatus Property

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 ISO character padding behavior.


object
.AnsiPaddingStatus

object

An expression that evaluates to an object in the Applies To list

Boolean

Read-only

HRESULT GetAnsiPaddingStatus(LPBOOL pRetVal);

By default, Microsoft SQL Server trims trailing blanks, or null bytes, from variable-length character or binary column data when values are inserted. The ISO standard requires trailing blanks and null bytes are not trimmed as data is inserted.

Community Additions

ADD
Show:
© 2016 Microsoft