CHARACTER_SETS Rowset

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