- Documentation Library
- Table of Contents
- MySQL 6.0 Reference Manual
- MySQL 5.1 Reference Manual
- MySQL 5.0 Reference Manual
- MySQL 3.23/4.0/4.1 Manual
- Table of Contents
Additional languages
MySQL 6.0 Reference Manual :: 25 INFORMATION_SCHEMA Tables :: 25.10 The INFORMATION_SCHEMA COLLATIONS Table
Section Navigation [Toggle]
- 25 INFORMATION_SCHEMA Tables
- 25.1 The INFORMATION_SCHEMA SCHEMATA Table
- 25.2 The INFORMATION_SCHEMA TABLES Table
- 25.3 The INFORMATION_SCHEMA COLUMNS Table
- 25.4 The INFORMATION_SCHEMA STATISTICS Table
- 25.5 The INFORMATION_SCHEMA USER_PRIVILEGES Table
- 25.6 The INFORMATION_SCHEMA SCHEMA_PRIVILEGES Table
- 25.7 The INFORMATION_SCHEMA TABLE_PRIVILEGES Table
- 25.8 The INFORMATION_SCHEMA COLUMN_PRIVILEGES Table
- 25.9 The INFORMATION_SCHEMA CHARACTER_SETS Table
- 25.10 The INFORMATION_SCHEMA COLLATIONS Table
- 25.11 The INFORMATION_SCHEMA COLLATION_CHARACTER_SET_APPLICABILITY Table
- 25.12 The INFORMATION_SCHEMA TABLE_CONSTRAINTS Table
- 25.13 The INFORMATION_SCHEMA KEY_COLUMN_USAGE Table
- 25.14 The INFORMATION_SCHEMA ROUTINES Table
- 25.15 The INFORMATION_SCHEMA VIEWS Table
- 25.16 The INFORMATION_SCHEMA TRIGGERS Table
- 25.17 The INFORMATION_SCHEMA PLUGINS Table
- 25.18 The INFORMATION_SCHEMA ENGINES Table
- 25.19 The INFORMATION_SCHEMA PARTITIONS Table
- 25.20 The INFORMATION_SCHEMA EVENTS Table
- 25.21 The INFORMATION_SCHEMA FILES Table
- 25.22 The INFORMATION_SCHEMA PROCESSLIST Table
- 25.23 The INFORMATION_SCHEMA REFERENTIAL_CONSTRAINTS Table
- 25.24 The INFORMATION_SCHEMA GLOBAL_STATUS and SESSION_STATUS Tables
- 25.25 The INFORMATION_SCHEMA GLOBAL_VARIABLES and SESSION_VARIABLES Tables
- 25.26 The INFORMATION_SCHEMA PARAMETERS Table
- 25.27 The INFORMATION_SCHEMA PROFILING Table
- 25.28 Other INFORMATION_SCHEMA Tables
- 25.29 Extensions to SHOW Statements
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 |
The following statements are equivalent:
SELECT COLLATION_NAME FROM INFORMATION_SCHEMA.COLLATIONS [WHERE collation_name LIKE 'wild'] SHOW COLLATION [LIKE 'wild']
© 1995-2008 MySQL AB. All rights reserved.
User Comments
Add your own comment.