Modify View MySQL Character set (charset)

View MySQL's character set

Mysql> Show variables like ' collation_% ';
+----------------------+-----------------+
| variable_name | Value |
+----------------------+-----------------+
| collation_connection | Utf8_general_ci |
| Collation_database | Utf8_general_ci |
| Collation_server | Utf8_general_ci |
+----------------------+-----------------+
3 Rows in Set (0.01SEC)
Mysql> Show variables like ' character_set_% ';
+--------------------------+----------------------------+
| variable_name | Value |
+--------------------------+----------------------------+
| character_set_client | UTF8 |
| character_set_connection | UTF8 |
| Character_set_database | UTF8 |
| Character_set_filesystem | binary |
| Character_set_results | UTF8 |
| Character_set_server | UTF8 |
| Character_set_system | UTF8 |
| Character_sets_dir | /usr/share/mysql/charsets/|
+--------------------------+----------------------------+
8 rows in Set (0.01 sec)
Mysql>
Modifying the character set of a database
Mysql>use DatabaseName

Mysql>alter database databaseName character set UTF8;
Specify the character set of the database when you create the database
Mysql>create database databaseName character set UTF8;

Besides, the problem of setting MySQL case sensitive under Linux and setting the default font set

Vi/etc/my.cnf

Join under [mysqld]

lower_case_table_names=1//is case-insensitive, 0 is to be differentiated.

default-character-set=utf8//setting the server-side character set to * * *

Add under [client]
Default-character-set=utf8

(go) Modify view MySQL character set (charset)