The CHARACTER_SETS rowset identifies the character sets defined in the catalog that are accessible to a given user.
The CHARACTER_SETS rowset contains the following columns.
Column name | Type indicator | Description |
CHARACTER_SET_ CATALOG |
DBTYPE_WSTR | Catalog name. NULL if the provider does not support catalogs. |
CHARACTER_SET_ SCHEMA |
DBTYPE_WSTR | Unqualified schema name. NULL if the provider does not support schemas. |
CHARACTER_SET_NAME | DBTYPE_WSTR | Character set name. |
FORM_OF_USE | DBTYPE_WSTR | Name of form-of-use of the character set. |
NUMBER_OF_ CHARACTERS |
DBTYPE_I8 | Number of characters in the character repertoire. |
DEFAULT_COLLATE_ CATALOG |
DBTYPE_WSTR | Catalog name containing the default collation. NULL if the provider does not support catalogs or different collations. |
DEFAULT_COLLATE_ SCHEMA |
DBTYPE_WSTR | Unqualified schema name containing the default collation. NULL if the provider does not support schemas or different collations. |
DEFAULT_COLLATE_ NAME |
DBTYPE_WSTR | Default collation. NULL if the provider does not support different collations. |
Default Sort Order: CHARACTER_SET_CATALOG, CHARACTER_SET_SCHEMA, CHARACTER_SET_NAME