- Documentation Library
- Table of Contents
- MySQL 5.0 Manual
- Table of Contents
MySQL 5.0 Reference Manual :: 22 La base de données d'informations INFORMATION_SCHEMA :: 22.1 Les tables INFORMATION_SCHEMA :: 22.1.9 La table INFORMATION_SCHEMA CHARACTER_SETS
Section Navigation [Toggle]
- 22.1 Les tables INFORMATION_SCHEMA
- 22.1.1 La table INFORMATION_SCHEMA SCHEMATA
- 22.1.2 La table INFORMATION_SCHEMA TABLES
- 22.1.3 La table INFORMATION_SCHEMA COLUMNS
- 22.1.4 La table INFORMATION_SCHEMA STATISTICS
- 22.1.5 La table INFORMATION_SCHEMA USER_PRIVILEGES
- 22.1.6 La table INFORMATION_SCHEMA SCHEMA_PRIVILEGES
- 22.1.7 La table INFORMATION_SCHEMA TABLE_PRIVILEGES
- 22.1.8 La table INFORMATION_SCHEMA COLUMN_PRIVILEGES
- 22.1.9 La table INFORMATION_SCHEMA CHARACTER_SETS
- 22.1.10 La table INFORMATION_SCHEMA COLLATIONS
- 22.1.11 La table INFORMATION_SCHEMA COLLATION_CHARACTER_SET_APPLICABILITY
- 22.1.12 La table INFORMATION_SCHEMA TABLE_CONSTRAINTS
- 22.1.13 La table INFORMATION_SCHEMA KEY_COLUMN_USAGE
- 22.1.14 La table INFORMATION_SCHEMA ROUTINES
- 22.1.15 La table INFORMATION_SCHEMA VIEWS
- 22.1.16 Autres tables INFORMATION_SCHEMA
La table CHARACTER_SETS fournit des
informations sur les jeux de caractères disponibles.
| Nom standard | Nom SHOW |
Remarques |
CHARACTER_SET_CATALOG |
omis | |
CHARACTER_SET_SCHEMA |
omis | |
CHARACTER_SET_NAME |
Charset |
|
CHARACTER_REPERTOIRE |
omis | |
FORM_OF_USE |
omis | |
NUMBER_OF_CHARACTERS |
omis | |
DEFAULT_COLLATE_CATALOG |
omis | |
DEFAULT_COLLATE_SCHEMA |
omis | |
DEFAULT_COLLATE_NAME |
Default collation |
|
DESCRIPION |
Description |
Extension MySQL |
MAXLEN |
Maxlen |
Extension MySQL |
Notes :
Nous avons ajouté 2 colonnes non standard qui sont
DescriptionetMaxlen, dans la commandeSHOW CHARACTER SET.
Les commandes suivantes sont équivalentes :
SELECT * FROM INFORMATION_SCHEMA.CHARACTER_SETS [WHERE name LIKE 'wild'] SHOW CHARACTER SET [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.
