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.
Collation information is also available from the
SHOW COLLATION
statement. The
following statements are equivalent:
SELECT COLLATION_NAME FROM INFORMATION_SCHEMA.COLLATIONS [WHERE COLLATION_NAME LIKE 'wild
'] SHOW COLLATION [LIKE 'wild
']
User Comments
Add your own comment.