Modify MySQL code to UTF-8

Mysql>Show variables like '%character%';+--------------------------+----------------------------+|Variable_name|Value|+--------------------------+----------------------------+|Character_set_client|Utf8||Character_set_connection|Utf8||Character_set_database|Latin1||Character_set_filesystem| binary                     ||Character_set_results|Utf8||Character_set_server|Latin1||Character_set_system|Utf8||Character_sets_dir| /Usr/Share/Mysql/Charsets/ |+--------------------------+----------------------------+8Rowsinch Set(0.00Sec

Modifying the character set of a database
Mysql>use mydb Mysql>alter Database mydb character Set utf-8;

Creating a database Specifies the character set of the database Mysql>create mydb character set utf-8;

Modify by configuration file:

Modify/var/lib/mysql/mydb/db.opt
Default-character-set=latin1
Default-collation=latin1_swedish_ci
For
Default-character-set=utf8
Default-collation=utf8_general_ci

Re-starting MySQL:
[Email protected] ~]#/etc/rc.d/init.d/mysql restart

Modified via MySQL command line:

Mysql> set Character_set_client=utf8;
Query OK, 0 rows affected (0.00SEC)

Mysql> set Character_set_connection=utf8;
Query OK, 0 rows affected (0.00SEC)

Mysql> set Character_set_database=utf8;
Query OK, 0 rows affected (0.00SEC)

Mysql> set Character_set_results=utf8;
Query OK, 0 rows affected (0.00SEC)

Mysql> set Character_set_server=utf8;
Query OK, 0 rows affected (0.00SEC)

Mysql> set Character_set_system=utf8;
Query OK, 0 rows affected (0.01SEC)

Mysql> set Collation_connection=utf8;
Query OK, 0 rows affected (0.01SEC)

Mysql> set Collation_database=utf8;
Query OK, 0 rows affected (0.01SEC)

Mysql> set Collation_server=utf8;
Query OK, 0 rows affected (0.01SEC)

Modify MySQL code to UTF-8