Skip navigation links
22.1.11 La table INFORMATION_SCHEMA COLLATION_CHARACTER_SET_APPLICABILITY »
Section Navigation      [Toggle]

22.1.10. La table INFORMATION_SCHEMA COLLATIONS

La table COLLATIONS fournit des informations sur les collations de chaque jeu de caractères.

Nom standard Nom SHOW Remarques
COLLATION_CATALOG   omis;
COLLATION_SCHEMA   omis;
COLLATION_NAME Collation  
PAD_ATTRIBUTE   omis;
COLLATION_TYPE   omis;
COLLATION_DEFINITION   omis;
COLLATION_DICTIONARY   omis;
CHARACTER_SET_NAME   omis; extension de MySQL
ID   omis; extension de MySQL
IS_DEFAULT   omis; extension de MySQL
IS_COMPILED   omis; extension de MySQL
SORTLEN   omis; extension de MySQL

Notes :

  • Nous avons ajouté 5 colonnes non standard qui correspondent au Charset, Id, Default, Compiled et Sortlen dans le résultat de SHOW COLLATION.

Les commandes suivantes sont équivalentes : 

SELECT COLLATION_NAME FROM INFORMATION_SCHEMA.COLLATIONS
  [WHERE collation_name LIKE 'wild']

SHOW COLLATION
  [LIKE 'wild']

This is a translation of the MySQL Reference Manual that can be found at dev.mysql.com. The original Reference Manual is in English, and this translation is not necessarily as up to date as the English version.