Concepts > Attributes (MetaAttributes) > COLLATE \ MySQL
COLLATE \ MySQL
Every 'character' column (that is, a column of type CHAR, VARCHAR, or TEXT) has a column character set and a column collation. Column definition syntax has optional clauses for specifying the column character set and collation:
col_name {CHAR | VARCHAR | TEXT} (col_length)
[CHARACTER SET charset_name] [COLLATE collation_name]
 
Example:
CREATE TABLE Table1
(
column1 VARCHAR(5) CHARACTER SET latin1 COLLATE latin1_german1_ci
);
MySQL chooses the column character set and collation in the following manner:
- If both CHARACTER SET X and COLLATE Y were specified, then character set X and collation Y
are used.
- If CHARACTER SET X was specified without COLLATE, then character set X and its default collation
are used.
- If COLLATE Y was specified without CHARACTER SET, then the character set associated with Y
and collation Y.
- Otherwise, the table character set and collation are used.
The CHARACTER SET and COLLATE clauses are standard SQL.
Translations
Type
String (63) Enumeration
 
List of MetaClasses
Value
(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).