Manual:collation table

Normalization table for collation names.

Primary key.

Collation name.

DESCRIBEcollation;

+----------------+----------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+----------------+----------------------+------+-----+---------+----------------+
| collation_id | smallint(5) unsigned | NO | PRI | NULL | auto_increment |
| collation_name | varbinary(64) | NO | UNI | NULL | |
+----------------+----------------------+------+-----+---------+----------------+

SHOWINDEXINcollation;

+-----------+------------+----------------+--------------+----------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |
+-----------+------------+----------------+--------------+----------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| collation | 0 | PRIMARY | 1 | collation_id | A | 0 | NULL | NULL | | BTREE | | |
| collation | 0 | collation_name | 1 | collation_name | A | 0 | NULL | NULL | | BTREE | | |
+-----------+------------+----------------+--------------+----------------+-----------+-------------+----------+--------+------+------------+---------+---------------+