Ubuntu中修改mysql的编码方式为uft8

Ubuntu中mysql设置数据库为UTF8编码的方法

mysql中若没有设置utf8编码,则无法在表中插入中文字符,否则会出现如下所示的错误:

mysql> insert into person values(1, '黎明');
ERROR 1366 (HY000): Incorrect string value: '\xE9\xBB\x8E\xE6\x98\x8E' for column 'name' at row 1*

在不修改ubuntu 中mysql的配置文件/etc/my.cnf文件的情况下可以进行如下操作:

1.新建database之前修改数据库的编码方式:
首先使用show variables like '%chara%;显示现在的编码方式:

show variables like '%chara%';
+--------------------------+----------------------------+
| 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     | latin1                     |
| character_set_system     | utf8                       |
| character_sets_dir       | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+
8 rows in set (0.00 sec)

2.然后使用set character_set_server=utf8;和set character_set_database=utf8;将其配置为utf8编码方式,再次使用show variables like '%chara%';结果显示如下;

show variables like '%chara%';
+--------------------------+----------------------------+
| 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.00 sec)

3.新建database以及table,此时在table中插入中文字符就没有问题了.

 create database test1;
Query OK, 1 row affected (0.00 sec)

 use test1;
Database changed

create table person(
    -> id int,
    -> name varchar(20)
    -> );
Query OK, 0 rows affected (0.02 sec)

insert into person values(1,'李明');
Query OK, 1 row affected (0.00 sec)