Spec-Zone .ru
спецификации, руководства, описания, API
|
|
Spec-Zone .ru
спецификации, руководства, описания, API
|
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']