# Information Schema CHARACTER\_SETS Table

The [Information Schema](https://mariadb.com/docs/server/reference/system-tables/information-schema) `CHARACTER_SETS` table contains a list of supported [character sets](https://mariadb.com/docs/server/reference/data-types/string-data-types/character-sets), their default collations and maximum lengths.

It contains the following columns:

| Column                 | Description                |
| ---------------------- | -------------------------- |
| CHARACTER\_SET\_NAME   | Name of the character set. |
| DEFAULT\_COLLATE\_NAME | Default collation used.    |
| DESCRIPTION            | Character set description. |
| MAXLEN                 | Maximum length.            |

The [SHOW CHARACTER SET](https://mariadb.com/docs/server/reference/sql-statements/administrative-sql-statements/show/show-character-set) statement returns the same results (although in a different order), and both can be refined in the same way. For example, the following two statements return the same results:

```sql
SHOW CHARACTER SET WHERE Maxlen LIKE '2';
```

and

```sql
SELECT * FROM information_schema.CHARACTER_SETS 
WHERE MAXLEN LIKE '2';
```

See [Setting Character Sets and Collations](https://mariadb.com/docs/server/reference/data-types/string-data-types/character-sets/setting-character-sets-and-collations) for details on specifying the character set at the server, database, table and column levels, and [Supported Character Sets and Collations](https://mariadb.com/docs/server/reference/data-types/string-data-types/character-sets/supported-character-sets-and-collations) for a full list of supported characters sets and collations.

## Example

```sql
SELECT CHARACTER_SET_NAME FROM information_schema.CHARACTER_SETS 
WHERE DEFAULT_COLLATE_NAME LIKE '%chinese%';
+--------------------+
| CHARACTER_SET_NAME |
+--------------------+
| big5               |
| gb2312             |
| gbk                |
+--------------------+
```

<sub>*This page is licensed: CC BY-SA / Gnu FDL*</sub>

{% @marketo/form formId="4316" %}