The character_sets view provides information about all character sets available in the current database.
| Column name | Data type | Description |
|---|---|---|
character_set_catalog |
sql_identifier |
Character sets are not implemented as schema objects. The column is always NULL. |
character_set_schema |
sql_identifier |
Character sets are not implemented as schema objects. The column is always NULL. |
character_set_name |
sql_identifier |
The name of the character set, which matches the database encoding name. |
character_repertoire |
sql_identifier |
The character repertoire.UCS if the encoding is UTF8. Otherwise, the encoding name. |
form_of_use |
sql_identifier |
The character encoding form which is the same as the database encoding. |
default_collate_catalog |
sql_identifier |
The name of the current database containing the default collation. |
default_collate_schema |
sql_identifier |
The name of the schema containing the default collation. |
default_collate_name |
sql_identifier |
The name of the default collation. The default collation is the one matching the COLLATE and CTYPE settings of the current database. If no matching collation exists, this column, its associated schema, and catalog columns are NULL. |