Collation Property

未來的 Microsoft SQL Server 發行版本將不再提供此功能。請避免在新的開發工作中使用此功能,並計劃修改目前使用此功能的應用程式。

The Collation property returns the column-level collation of an object.

語法

object
.
Collation

Parts

  • object
    An expression that evaluates to an object in the Applies To list
  • value
    A string that returns a valid Microsoft SQL Server™ collation name

Data Type

String

Modifiable

Varies (See Remarks)

Prototype (C/C++)

HRESULT GetCollation(SQLDMO_LPBSTR pRetVal);
HRESULT SetCollation(SQLDMO_LPCSTR NewValue);

備註

Collation is a read-write property of the Column2 and Database2 objects. A Collation setting for a Database2 object overrides the default collation specified in the model database. All tables in the database then inherit the Collation setting.

Collation is a read-only property of the SQLServer2, SystemDataType2, and UserDefinedDatatype2 objects and is used to retrieve the current collation for string data types.

If Collation is not set, the default collation is used. Collation can only be set when a new database or user-defined data type is created. Prior to setting the Collation property, use the ListCollations method to retrieve a list of valid collation names.

ms132063.note(zh-tw,SQL.90).gif附註:
If an application calls Collation on an instance of SQL Server version 7.0, the constant, SQLDMO_E_SQL80ONLY, and the message "This property or method requires Microsoft SQL Server 2000 or later" are returned.

Applies To:

Column2 Object

SystemDataType2 Object

Database2 Object

UserDefinedDataType2 Object

SQLServer2 Object

 

請參閱

參考

ListCollations Method

說明及資訊

取得 SQL Server 2005 協助