mysql5.0版本编译安装linux命令行下输入不了中文
mysql 5.02编译的时候指定了 charset gbk
my.cnf 里面 client mysqld 都指定了default charset gbk
系统locale gbk
进入linux mysql客户端 无法录入中文 ,虽然客运用别的方法避开这个问题,但是遇到过多次想探了究竟 希望得到高手指点
我也遇到了这样的问题而且 /etc/my.cnf文件默认也是default-character-set=gbk
mysql> show variables like '%character%';
-------------------------- ----------------------------------------
| Variable_name | Value |
-------------------------- ----------------------------------------
| character_set_client | gbk |
| character_set_connection | gbk |
| character_set_database | gbk |
| character_set_results | gbk |
| character_set_server | gbk |
| character_set_system | utf8 |
| character_sets_dir | /usr/local/mysql/share/mysql/charsets/ |
-------------------------- ----------------------------------------
7 rows in set (0.00 sec)
mysql> show variables like '%collation%';
---------------------- ----------------
| Variable_name | Value |
---------------------- ----------------
| collation_connection | gbk_chinese_ci |
| collation_database | gbk_chinese_ci |
| collation_server | gbk_chinese_ci |
---------------------- ----------------
解决方法:
/var/soft/mysql/bin/mysql -uroot < use db;
insert into table values(aaaa,ssss,);
EOF
