AnsiPaddingStatus Property

SQL-DMO

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.