MySQL garbled problem

A.mysql settings

1.service MySQL Stop

2.sudo vim/etc/mysql/my.cnf

Add the following two lines in [mysqld]

　　　　　　Character_set_server = UTF8

Init_connect = ' SET NAMES UTF8 '
3.service MySQL Start

B. Building the library and building the table code plus character set encoding

Create Database ' db_name ' DEFAULT CHARACTER SET UTF8 COLLATE utf8_general_ci;

CREATE TABLE ' Tb_name ' (ID varchar (primary) key ...) engine=innodb default character Set=utf8;

or modify the character set encoding for libraries and tables that already exist

　　　　ALTER DATABASE ' db_name ' DEFAULT CHARACTER SET UTF8 COLLATE utf8_general_ci;

　　　　ALTER TABLE ' tb_name ' DEFAULT CHARACTER SET UTF8 COLLATE utf8_general_ci;

C. URL of the call plus character set encoding

url = jdbc:mysql:///' db_name '? Useunicode=true&characterencoding=utf8

MySQL garbled problem