Show Collation Syntax in MySQL

Posted by admin

May 6, 2008

SHOW COLLATION [LIKE ‘pattern’]

The output from SHOW COLLATION includes all available character sets. It takes an optional
LIKE clause that indicates which collation names to match.

For example:

mysql> SHOW COLLATION LIKE ‘latin1%’;
+——————-+———+—-+———+———-+———+
| Collation | Charset | Id | Default | Compiled | Sortlen |
+——————-+———+—-+———+———-+———+
| latin1_german1_ci | latin1 | 5 | | | 0 |
| latin1_swedish_ci | latin1 | 8 | Yes | Yes | 0 |
| latin1_danish_ci | latin1 | 15 | | | 0 |
| latin1_german2_ci | latin1 | 31 | | Yes | 2 |
| latin1_bin | latin1 | 47 | | Yes | 0 |
| latin1_general_ci | latin1 | 48 | | | 0 |
| latin1_general_cs | latin1 | 49 | | | 0 |
| latin1_spanish_ci | latin1 | 94 | | | 0 |
+——————-+———+—-+———+———-+———+

The Default column indicates whether a collation is the default for its character set.
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.
SHOW COLLATION is available as of MySQL 4.1.0.

Share and Enjoy: These icons link to social bookmarking sites where readers can share and discover new web pages.