# COLLATIONS

This view stores information about collations for each character set.

| Column Name          | Description                                                                                          |
| -------------------- | ---------------------------------------------------------------------------------------------------- |
| `COLLATION_NAME`     | The collation name.                                                                                  |
| `CHARACTER_SET_NAME` | The name of the associated character set for a given collation.                                      |
| `ID`                 | The unique`ID`for a given collation.                                                                 |
| `IS_DEFAULT`         | `YES`if given collation is a the default for its character set, otherwise blank.                     |
| `IS_COMPILED`        | Whether or not the character set is fully compiled.                                                  |
| `SORTLEN`            | The amount of memory, in bytes, required in order for strings of a given character set to be sorted. |

***

Modified at: August 29, 2022

Source: [/db/v9.1/reference/information-schema-reference/cluster-component/collations/](https://docs.singlestore.com/db/v9.1/reference/information-schema-reference/cluster-component/collations/)

(An index of the documentation is available at /llms.txt)