linux下,如何把 utf8 的数据库改成gb2312的阿? /*!40101 SET NAMES utf8 */; /*!40101 SET NAMES gb2312 */; 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 没什么好办法,先倒出成xxx.sql 文件,然后重新数据库后再倒入。 mysql >set names 'gb2312';mysql> create database dd;bash-3.00# mysqldump -uroot -p123456 --opt dd> /home/s1.db做完以上三步后,打开s1.db文件,发现下面的注释怎么那样阿?/*!40101 SET NAMES utf8 */; 我不知道怎么变成/*!40101 SET NAMES gb2312 */; set names 并没有改变MYSQL服务器的默认字符集设置。create database dd CHARACTER SET gb2312; 那set names 'gb2312'; 怎么用阿? set names 'gb2312'; 只是改变的连接中的字符集设置。具体怎么用,要根据你的实际情况。 sql>create database student character set gb2312;bash-3.00# mysqldump -uroot -p123456 --opt student> /home/student.db做完了上边的两步后,生成的/home/student.db里面,怎么还是/*!40101 SET NAMES utf8 */;阿? mysql> show variables like 'char%';+--------------------------+----------------------------+| Variable_name | Value |+--------------------------+----------------------------+| character_set_client | gb2312 || character_set_connection | gb2312 || character_set_database | gb2312 || character_set_filesystem | binary || character_set_results | gb2312 || character_set_server | gb2312 || character_set_system | utf8 || character_sets_dir | /usr/share/mysql/charsets/ |+--------------------------+----------------------------+mysql> select * from s2;+------+--------+| id | name |+------+--------+| 1 | 恭敬现 || 2 | 我 || 3 | 国精明 |+------+--------+3 rows in set (0.00 sec)mysql> show create table s2;+-------+-----------------------------------------------------------------------------------------------------------------------+| Table | Create Table |+-------+-----------------------------------------------------------------------------------------------------------------------+| s2 | CREATE TABLE `s2` ( `id` int(3) default NULL, `name` char(10) default NULL) ENGINE=MyISAM DEFAULT CHARSET=gb2312 |+-------+-----------------------------------------------------------------------------------------------------------------------+1 row in set (0.00 sec) mongos 实例启动出错 关于mySQL数据 服务经常停止的问题 mysql自定义函数 高手来解决下! 20W人以上在线,MYSQL服务器怎么建设 【新手求助】为啥xp下java连不上mysql呢? 终于编译通过Win32版的MySQL了(支持中文全文索引的),散分…… 新手上路,寻觅好书!!! Leave语句能作为存储过程的跳出语句吗? MySql workbench 6.08 中不能向数据表中添加数据,没有添加选项or 权限不够? 用sql语句获得一个月的日期 按下面的样式显示查询结果 二进制日志文件问题 怎样把mysql中的数据库转到sybase中?
mysql> create database dd;
bash-3.00# mysqldump -uroot -p123456 --opt dd> /home/s1.db做完以上三步后,打开s1.db文件,发现下面的注释怎么那样阿?
/*!40101 SET NAMES utf8 */;
我不知道怎么变成/*!40101 SET NAMES gb2312 */;
bash-3.00# mysqldump -uroot -p123456 --opt student> /home/student.db做完了上边的两步后,生成的/home/student.db里面,怎么还是/*!40101 SET NAMES utf8 */;阿? mysql> show variables like 'char%';
+--------------------------+----------------------------+
| Variable_name | Value |
+--------------------------+----------------------------+
| character_set_client | gb2312 |
| character_set_connection | gb2312 |
| character_set_database | gb2312 |
| character_set_filesystem | binary |
| character_set_results | gb2312 |
| character_set_server | gb2312 |
| character_set_system | utf8 |
| character_sets_dir | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+
mysql> select * from s2;
+------+--------+
| id | name |
+------+--------+
| 1 | 恭敬现 |
| 2 | 我 |
| 3 | 国精明 |
+------+--------+
3 rows in set (0.00 sec)mysql> show create table s2;
+-------+-----------------------------------------------------------------------------------------------------------------------+
| Table | Create Table |
+-------+-----------------------------------------------------------------------------------------------------------------------+
| s2 | CREATE TABLE `s2` (
`id` int(3) default NULL,
`name` char(10) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=gb2312 |
+-------+-----------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)