mysql中文乱码的问题
如题,插入表的时候插不进汉字:
mysql> CREATE TABLE t2(name varchar(20));
Query OK, 0 rows affected (0.08 sec)
mysql> insert into t2 values('张三');
ERROR 1406 (22001): Data too long for column 'name' at row 1
mysql> insert into t2 values('zhangsan');
Query OK, 1 row affected (0.06 sec)
mysql> SHOW VARIABLES LIKE 'character_set_%';
+--------------------------+----------------------------------------------------
-----+
| Variable_name | Value
|
+--------------------------+----------------------------------------------------
-----+
| character_set_client | gbk
|
| character_set_connection | gbk
|
| character_set_database | latin1
|
| character_set_filesystem | binary
|
| character_set_results | gbk
|
| character_set_server | latin1
|
| character_set_system | utf8
|
| character_sets_dir | C:\Program Files\MySQL\MySQL Server 5.0\share\chars
ets\ |
+--------------------------+----------------------------------------------------
-----+
8 rows in set (0.00 sec)
已做的操作:
MY.INI:
default-character-set=latin1添加
default-character-set=gb2312
再
alter database charset = gb2312;
初学mysql,实在不知道怎么处理了,特来请教.