Share via


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.

Applies To:

Column Object