The view information_schema.character_sets identifies the character sets available in the database.
MonetDB uses a hardcoded character set encoding (UTF-8
) for all character data.
It does not support alternative or multiple character sets, hence this view returns only one row.
SELECT * FROM information_schema.character_sets;
SELECT character_set_name FROM information_schema.character_sets;
information_schema.character_sets
column name | type | remarks |
---|---|---|
character_set_catalog | VARCHAR | Always NULL |
character_set_schema | VARCHAR | Always NULL |
character_set_name | VARCHAR | UTF-8 |
character_repertoire | VARCHAR | ISO/IEC 10646:2021 |
form_of_use | VARCHAR | UTF-8 |
default_collate_catalog | VARCHAR | Always NULL |
default_collate_schema | VARCHAR | Always NULL |
default_collate_name | VARCHAR | Always NULL |