mysql utf8 乱码_再整MySQL的中文UTF8问题

mysql> SHOW VARIABLES LIKE 'character%';

+----------------------------------------+-------------------------

| Variable_name| Value

+----------------------------------------+-------------------------

| character_set_client | latin1

| character_set_connection   | latin1

| character_set_database    | utf8

| character_set_filesystem    | binary

| character_set_results| latin1

| character_set_server| utf8

| character_set_system| utf8

| character_sets_dir| D:\mysql\share\charsets\

+----------------------------------------+-------------------------

8 rows in set (0.00 sec)

mysql> SHOW VARIABLES LIKE 'collation_%';

+---------------------------------------+------------------

| Variable_name| Value

+---------------------------------------+------------------

| collation_connection | latin1_swedish_ci

| collation_database| utf8_general_ci

| collation_server| utf8_general_ci

+--------------------------------------+------------------

3 rows in set (0.00 sec)