20.10. The INFORMATION_SCHEMA COLLATIONS Table

JavaScript Editor Source code editor What Is Ajax
↑

20.10. The `INFORMATION_SCHEMA COLLATIONS` Table

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']

JavaScript Editor Source code editor What Is Ajax