MaximumLength Property

  • [アーティクル]

この機能は、将来のバージョンの Microsoft SQL Server では削除される予定です。新規の開発作業ではこの機能を使用しないようにし、現在この機能を使用しているアプリケーションは修正することを検討してください。

The MaximumLength property identifies the greatest length of a data type in bytes, or the precision of the type.

構文

object
.MaximumLength

Parts

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

Data Type

Long

Modifiable

Read-only

Prototype (C/C++)

HRESULT GetMaximumLength(LPLONG pRetVal);

解説

For binary and character data types, the MaximumLength property identifies the greatest number of bytes required to store a string of the type. For example, the SystemDatatype object referencing the varchar data type reports 8,000. The varchar data type can contain up to 8,000 bytes of data. The number of characters contained in the string is determined by the mix of single and multibyte characters within it.

For the fixed-precision, numeric data types, the MaximumLength property specifies the maximum precision of the type.

For all other referenced data types, the MaximumLength property identifies the number of bytes required to store a value of the type in a Microsoft SQL Server structure representing the type.

Applies To:

SystemDatatype Object