Concepts > Attributs (MetaAttributes) > COLLATE \ MySQL
COLLATE \ MySQL
Chaque colonne de character'' (c'est à dire les colonnes de type CHAR, VARCHAR, ou TEXT) a un jeu de caractères de colonne et une collation de colonne qui ne peut pas être nulle. La syntaxe de définition de colonne a maintenant des clauses optionnelles pour préciser le jeu de caractères de colonne et la collation :
column_name {CHAR | VARCHAR | TEXT} (column_length)
[CHARACTER SET character_set_name [COLLATE collation_name]]
 
Exemple :
CREATE TABLE Table1
(
column1 VARCHAR(5) CHARACTER SET latin1 COLLATE latin1_german1_ci
);
MySQL choisit le jeu de caractères et la collation de colonne comme ceci :
- Si CHARACTER SET X et COLLATE Y sont spécifiés, alors le jeu de caractères est X et la
collation Y.
- Si CHARACTER SET X a été spécifié sans la clause COLLATE, alors le jeu de caractères est X
et la collation est sa collation par défaut.
- Sinon, MySQL utilise le jeu de caractères et la collation par défaut.
Les clauses CHARACTER SET et COLLATE font partie du standard SQL.
Traductions
Type
String (63) Enumeration
 
Liste des MetaClasses
.
Valeur
(armscii8_bin), (armscii8_general_ci), (ascii_bin), (ascii_general_ci), (big5_bin), (big5_chinese_ci), (binary), (cp1250_bin), (cp1250_croatian_ci), (cp1250_czech_cs), (cp1250_general_ci), (cp1251_bin), (cp1251_bulgarian_ci), (cp1251_general_ci), (cp1251_general_cs), (cp1251_ukrainian_ci), (cp1256_bin), (cp1256_general_ci), (cp1257_bin), (cp1257_general_ci), (cp1257_lithuanian_ci), (cp850_bin), (cp850_general_ci), (cp852_bin), (cp852_general_ci), (cp866_bin), (cp866_general_ci), (cp932_bin), (cp932_japanese_ci), (dec8_bin), (dec8_swedish_ci), (eucjpms_bin), (eucjpms_japanese_ci), (euckr_bin), (euckr_korean_ci), (gb2312_bin), (gb2312_chinese_ci), (gbk_bin), (gbk_chinese_ci), (geostd8_bin), (geostd8_general_ci), (greek_bin), (greek_general_ci), (hebrew_bin), (hebrew_general_ci), (hp8_bin), (hp8_english_ci), (keybcs2_bin), (keybcs2_general_ci), (koi8r_bin), (koi8r_general_ci), (koi8u_bin), (koi8u_general_ci), (latin1_bin), (latin1_danish_ci), (latin1_general_ci), (latin1_general_cs), (latin1_german1_ci), (latin1_german2_ci), (latin1_spanish_ci), (latin1_swedish_ci), (latin2_bin), (latin2_croatian_ci), (latin2_czech_cs), (latin2_general_ci), (latin2_hungarian_ci), (latin5_bin), (latin5_turkish_ci), (latin7_bin), (latin7_estonian_cs), (latin7_general_ci), (latin7_general_cs), (macce_bin), (macce_general_ci), (macroman_bin), (macroman_general_ci), (sjis_bin), (sjis_japanese_ci), (swe7_bin), (swe7_swedish_ci), (tis620_bin), (tis620_thai_ci), (ucs2_bin), (ucs2_czech_ci), (ucs2_danish_ci), (ucs2_esperanto_ci), (ucs2_estonian_ci), (ucs2_general_ci), (ucs2_icelandic_ci), (ucs2_latvian_ci), (ucs2_lithuanian_ci), (ucs2_persian_ci), (ucs2_polish_ci), (ucs2_romanian_ci), (ucs2_roman_ci), (ucs2_slovak_ci), (ucs2_slovenian_ci), (ucs2_spanish2_ci), (ucs2_spanish_ci), (ucs2_swedish_ci), (ucs2_turkish_ci), (ucs2_unicode_ci), (ujis_bin), (ujis_japanese_ci), (utf8_bin), (utf8_czech_ci), (utf8_danish_ci), (utf8_esperanto_ci), (utf8_estonian_ci), (utf8_general_ci), (utf8_icelandic_ci), (utf8_latvian_ci), (utf8_lithuanian_ci), (utf8_persian_ci), (utf8_polish_ci), (utf8_romanian_ci), (utf8_roman_ci), (utf8_slovak_ci), (utf8_slovenian_ci), (utf8_spanish2_ci), (utf8_spanish_ci), (utf8_swedish_ci), (utf8_turkish_ci), (utf8_unicode_ci).