There are a variety of MySQL character sets, the following is a list of three of the most common MySQL character set viewing methods, this method for your reference, I hope you learn MySQL database can be enlightened.
One, view MySQL database server and database MySQL character set.
Mysql> Show variables like '%char% ';
+--------------------------+-------------------------------------+------
| variable_name | Value |
+--------------------------+-------------------------------------+------
| character_set_client | UTF8 |--Client Character Set
| character_set_connection | UTF8 |
| Character_set_database | UTF8 |--database Character Set
| Character_set_filesystem | binary |
| Character_set_results | UTF8 |
| Character_set_server | UTF8 |--server Character Set
| Character_set_system | UTF8 |
| Character_sets_dir | D:\MySQL Server 5.0\share\charsets\ |
+--------------------------+-------------------------------------+------
Second, look at the MySQL data Table (table) of the MySQL character set.
Mysql> Show Table status from sqlstudy_db like '%countries% ';
+-----------+--------+---------+------------+------+-----------------+------
| Name | Engine | Version | Row_format | Rows | Collation |
+-----------+--------+---------+------------+------+-----------------+------
| Countries | InnoDB | 10 | Compact | 11 | Utf8_general_ci |
+-----------+--------+---------+------------+------+-----------------+------
Check the MySQL character set for MySQL data column (column).
Mysql> show full columns from countries;
+----------------------+-------------+-----------------+--------
| Field | Type | Collation | .......
+----------------------+-------------+-----------------+--------
| countries_id | Int (11) | NULL | .......
| Countries_name | VARCHAR (64) | Utf8_general_ci | .......
| countries_iso_code_2 | char (2) | Utf8_general_ci | .......
| Countries_iso_code_3 | CHAR (3) | Utf8_general_ci | .......
| address_format_id | Int (11) | NULL | .......
MySQL methods and commands for viewing character sets