OLE DB Programmer's Reference |
GUID: DBSCHEMA_COLLATIONS
Number of restriction columns: 3
Restriction columns: COLLATION_CATALOG, COLLATION_SCHEMA COLLATION_NAME
Default sort order: COLLATION_CATALOG, COLLATION_SCHEMA, COLLATION_CATALOG, CHARACTER_SET_CATALOG, CHARACTER_SET_SCHEMA, CHARACTER_SET_NAME
Description: The COLLATIONS rowset identifies the character collations defined in the catalog that are accessible to a given user.
Column name | Type indicator | Description |
---|---|---|
COLLATION_CATALOG | DBTYPE_WSTR | Catalog name. NULL if the provider does not support catalogs. |
COLLATION_SCHEMA | DBTYPE_WSTR | Unqualified schema name. NULL if the provider does not support schemas. |
COLLATION_NAME | DBTYPE_WSTR | Collation name. |
CHARACTER_SET_CATALOG | DBTYPE_WSTR | Catalog name containing the character set on which the collation is defined. NULL if the provider does not support catalogs or different character sets. |
CHARACTER_SET_SCHEMA | DBTYPE_WSTR | Unqualified schema name containing the character set on which the collation is defined. NULL if the provider does not support schema or different character sets. |
CHARACTER_SET_NAME | DBTYPE_WSTR | Character set name on which the collation is defined. NULL if the provider does not support different character sets. |
PAD_ATTRIBUTE | DBTYPE_WSTR | "NO PAD"The collation being described has the NO PAD attribute. "PAD SPACE"The collation being described has the PAD SPACE attribute. |
1998-2001 Microsoft Corporation. All rights reserved.