See methods for three MySQL character sets (go)

Http://database.51cto.com/art/201010/229171.htm

*****************************************

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.

2. MySQL> Show variables like '%char% ';
4. +--------------------------+-------------------------------------+------
6. | variable_name | Value |
8. +--------------------------+-------------------------------------+------
10. | character_set_client | UTF8 |--Client Character Set
12. | character_set_connection | UTF8 |
14. | Character_set_database | UTF8 |--database Character Set
16. | Character_set_filesystem | binary |
18. | Character_set_results | UTF8 |
20. | Character_set_server | UTF8 |--server Character Set
22. | Character_set_system | UTF8 |
24. | Character_sets_dir | D:\MySQL Server 5.0\share\charsets\ |
26. +--------------------------+-------------------------------------+------

Second, look at the MySQL data Table (table) of the MySQL character set.

1. MySQL> Show table status from sqlstudy_db like '%countries% ';
2. +-----------+--------+---------+------------+------+-----------------+------
3. | Name | Engine | Version | Row_format | Rows | Collation |
4. +-----------+--------+---------+------------+------+-----------------+------
5. | Countries |      InnoDB | 10 |   Compact | 11 | Utf8_general_ci |
6. +-----------+--------+---------+------------+------+-----------------+------

Check the MySQL character set for MySQL data column (column).

2. MySQL> Show full columns from countries;
4. +----------------------+-------------+-----------------+--------
6. | Field | Type | Collation | .......
8. +----------------------+-------------+-----------------+--------
10. | countries_id | Int (11) | NULL | .......
12. | Countries_name | VARCHAR (64) | Utf8_general_ci | .......
14. | countries_iso_code_2 | char (2) | Utf8_general_ci | .......
16. | Countries_iso_code_3 | CHAR (3) | Utf8_general_ci | .......
18. | address_format_id | Int (11) | NULL | .......
20. +----------------------+-------------+-----------------+--------

See methods for three MySQL character sets (go)