该表包含每个字符集的所有信息
The COLLATIONS
table provides information about collations for each character set.
INFORMATION_SCHEMA Name | SHOW Name | Remarks |
---|---|---|
COLLATION_NAME | Collation | |
CHARACTER_SET_NAME | Charset | MySQL extension |
ID | Id | MySQL extension |
IS_DEFAULT | Default | MySQL extension |
IS_COMPILED | Compiled | MySQL extension |
SORTLEN | Sortlen | MySQL extension |
-
COLLATION_NAME
is the collation name. -
CHARACTER_SET_NAME
is the name of the character set with which the collation is associated. -
ID
is the collation ID. -
IS_DEFAULT
indicates whether the collation is the default for its character set. -
IS_COMPILED
indicates whether the character set is compiled into the server. -
SORTLEN
is related to the amount of memory required to sort strings expressed in the character set.
查看方式:
1.SELECT COLLATION_NAME FROM INFORMATION_SCHEMA.COLLATIONS [WHERE COLLATION_NAME LIKE 'wild']
2.SHOW COLLATION [LIKE 'wild']