content_image/728377.jpg content_image/728378.jpg
SHOW COLLATION  output has these columns: 

• Collation 

The collation name. 

• Charset 

The name of the character set with which the collation is associated. 

• Id 

The collation ID. 

• Default 

Whether the collation is the default for its character set. 

• Compiled 

Whether the character set is compiled into the server. 

• Sortlen 

This is related to the amount of memory required to sort strings expressed in the character set. 

To see the default collation for each character set, use the following statement. Default  is a reserved word, so to use it as an identifier, it must be quoted as such: 

mysql> SHOW COLLATION WHERE ‘Default‘ = ’Yes’; 

<img src='content_image/728377.jpg'>

Collation information is also available from the INFORMATION_SCHEMA COLLATIONS  table. See Section 26.3.6, “The INFORMATION_SCHEMA COLLATIONS Table” . 

## 13.7.7.5 SHOW COLUMNS Statement 

SHOW [EXTENDED] [FULL] {COLUMNS | FIELDS} {FROM | IN} tbl_name [{FROM | IN} db_name ] [LIKE ’ pattern ’ | WHERE expr ] 

SHOW COLUMNS  displays information about the columns in a given table. It also works for views. SHOW COLUMNS  displays information only for those columns for which you have some privilege. 

mysql> SHOW COLUMNS FROM City; 

<img src='content_image/728378.jpg'>

