COLLATIONS Rowset
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. |