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 |