AnsiPaddingStatus Property (SQL-DMO)

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

Part	Description
object	Expression that evaluates to an object in the Applies To list

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.

Data Type

Boolean

Modifiable

Read-only

Prototype (C/C++)

HRESULT GetAnsiPaddingStatus(LPBOOL pRetVal);