Character set available in MySQL
MySQL offers several types of charset (CHARACTER_SET), thereby satisfying the most varied projects.
See character set supported by the MySQL Server
> SHOW CHARACTER SET; +----------+-----------------------------+--------------------- | Charset | Description | Default collation +----------+-----------------------------+-------------------- | big5 | Big5 Traditional Chinese | big5_chinese_ci | dec8 | DEC West European | dec8_swedish_ci | cp850 | DOS West European | cp850_general_ci | hp8 | HP West European | hp8_english_ci | koi8r | KOI8-R Relcom Russian | koi8r_general_ci | latin1 | cp1252 West European | latin1_swedish_ci | latin2 | ISO 8859-2 Central European | latin2_general_ci | swe7 | 7bit Swedish | swe7_swedish_ci | ascii | US ASCII | ascii_general_ci ....
See available COLLATION for a CHARACTER SET
> SELECT COLLATION_NAME FROM INFORMATION_SCHEMA.COLLATIONS WHERE CHARACTER_SET_NAME = 'utf8'; +--------------------+ | COLLATION_NAME | +--------------------+ | utf8_general_ci | | utf8_bin | | utf8_unicode_ci | | utf8_icelandic_ci | | utf8_latvian_ci | | utf8_romanian_ci | | utf8_slovenian_ci | ...
See COLLATION, CHARACTER_SET for the columns in a particular table
Here we take as an example the BD: Sakila
> SELECT COLUMN_NAME,COLLATION_NAME, CHARACTER_SET_NAME FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'actor' AND TABLE_SCHEMA = 'sakila'; +-------------+-----------------+--------------------+ | COLUMN_NAME | COLLATION_NAME | CHARACTER_SET_NAME | +-------------+-----------------+--------------------+ | actor_id | NULL | NULL | | first_name | utf8_general_ci | utf8 | | last_name | utf8_general_ci | utf8 | | last_update | NULL | NULL | +-------------+-----------------+--------------------+
Recommended reading
– F. van der lan, Rick. SQL for MySQL Developers, Part III, Chapter 22.
Character set available in MySQL Read More »