Collation Property
The Collation property returns the column-level collation of an object.
Applies To
| Column2 Object | SystemDataType2 Object |
| Database2 Object | UserDefinedDataType2 Object |
| SQLServer2 Object |
Syntax
object.Collation
Part
object
Expression that evaluates to an object in the Applies To list
value
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);
Remarks
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 model. 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 creating a new database or user-defined data type. Prior to setting the Collation property, use the ListCollations method to retrieve a list of valid collation names.
Note 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" are returned.