cjjwzs
- 浏览: 643230 次
- 性别:
- 来自: 杭州
-
文章分类
最新评论
-
HkEndless：
不好意思，请问这确定是回调机制吗。你的例子中只是将接口的实现类 ...
Spring CallBack回调机制介绍 -
hanmiao：
写的真乱啊，完全不知所云...
Java如何调用可执行文件和批处理命令 -
junia_1：
junia_1 写道 shock: ...
为什么要使用EJB -
junia_1：
shock:
为什么要使用EJB -
coollifer：
不错
SQL Server数据导入到Oracle中的方法
D:mysql5>.binmysqld-max-nt.exe --console
061106 20:35:21 InnoDB: Started; log sequence number 0 43655
061106 20:35:22 [Note] .binmysqld-max-nt.exe: ready for connections.
Version: '5.0.18-nt-max' socket: '' port: 3306 MySQL Community Edition (GPL)
Microsoft Windows XP [版本 5.1.2600]
(C) 版权所有 1985-2001 Microsoft Corp.
C:Documents and SettingsAdministrator>cd d:mysql5bin
C:Documents and SettingsAdministrator>d:
D:mysql5bin>mysql -uroot
Welcome to the MySQL monitor. Commands end with ; or g.
Your MySQL connection id is 1 to server version: 5.0.18-nt-max
Type 'help;' or 'h' for help. Type 'c' to clear the buffer.
mysql> use test
Database changed
mysql> SHOW VARIABLES LIKE 'character_set%';
+--------------------------+---------------------------+
| Variable_name | Value |
+--------------------------+---------------------------+
| character_set_client | latin1 |
| character_set_connection | latin1 |
| character_set_database | latin1 |
| character_set_results | latin1 |
| character_set_server | latin1 |
| character_set_system | utf8 |
| character_sets_dir | D:mysql5sharecharsets |
+--------------------------+---------------------------+
7 rows in set (0.00 sec)
mysql> create table ad(name varchar(32));
Query OK, 0 rows affected (0.10 sec)
mysql> insert into ad values('汉字');
Query OK, 1 row affected (0.00 sec)
mysql> select * from ad;
+------+
| name |
+------+
| 汉字 |
+------+
1 row in set (0.00 sec)
mysql>
此时，插入、显示字段的汉字值都正确。
但是如果服务器启动的时候指定了字符集参数，或者配置文件里面包含字符集参数
情况就不同了
my.ini
[mysqld]
default-character-set=gbk
D:mysql5>.binmysqld-max-nt.exe --defaults-file=my.ini --ansi --console
InnoDB: Error: log file .ib_logfile0 is of different size 0 5242880 bytes
InnoDB: than specified in the .cnf file 0 8388608 bytes!
061106 21:31:06 [Note] .binmysqld-max-nt.exe: ready for connections.
Version: '5.0.18-nt-max' socket: '' port: 3306 MySQL Community Edition (GPL)
061106 21:37:46 [Note] .binmysqld-max-nt.exe: Normal shutdown
061106 21:37:48 [Note] .binmysqld-max-nt.exe: Shutdown complete
D:mysql5>binmysqld-max-nt.exe --character_set_server=gbk --console
InnoDB: Error: log file .ib_logfile0 is of different size 0 5242880 bytes
InnoDB: than specified in the .cnf file 0 8388608 bytes!
061106 21:39:55 [Note] binmysqld-max-nt.exe: ready for connections.
Version: '5.0.18-nt-max' socket: '' port: 3306 MySQL Community Edition (GPL)
此时，显示过去未指定字符集时建立的表并插入汉字的字段，显示是正常的
D:mysql5bin>mysql -uroot
Welcome to the MySQL monitor. Commands end with ; or g.
Your MySQL connection id is 1 to server version: 5.0.18-nt-max
Type 'help;' or 'h' for help. Type 'c' to clear the buffer.
mysql> use test
Database changed
mysql> select * from ad;
+------+
| name |
+------+
| 汉字 |
+------+
1 row in set (0.00 sec)
mysql> SHOW VARIABLES LIKE 'character_set%';
+--------------------------+---------------------------+
| Variable_name | Value |
+--------------------------+---------------------------+
| character_set_client | latin1 |
| character_set_connection | latin1 |
| character_set_database | gbk |
| character_set_results | latin1 |
| character_set_server | gbk |
| character_set_system | utf8 |
| character_sets_dir | D:mysql5sharecharsets |
+--------------------------+---------------------------+
7 rows in set (0.00 sec)
这个时候建立的表并插入汉字的字段，不能正确显示
mysql> create table ad2(name varchar(32));
Query OK, 0 rows affected (0.06 sec)
mysql> insert into ad2 values('汉字');
Query OK, 1 row affected, 1 warning (0.01 sec)
mysql> select * from ad2;
+------+
| name |
+------+
| ??? |
+------+
1 row in set (0.01 sec)
如果只在客户端设定character_set_results参数，那么不管服务器端是什么字符集时建立、插入汉字的表都显示不正确
mysql> set character_set_results='gbk';
Query OK, 0 rows affected (0.00 sec)
mysql> SHOW VARIABLES LIKE 'character_set%';
+--------------------------+---------------------------+
| Variable_name | Value |
+--------------------------+---------------------------+
| character_set_client | latin1 |
| character_set_connection | latin1 |
| character_set_database | gbk |
| character_set_results | gbk |
| character_set_server | gbk |
| character_set_system | utf8 |
| character_sets_dir | D:mysql5sharecharsets |
+--------------------------+---------------------------+
7 rows in set (0.00 sec)
mysql> select * from ad2;
+-------+
| name |
+-------+
| ??×? |
+-------+
1 row in set (0.00 sec)
mysql> select * from ad;
+-------+
| name |
+-------+
| ??×? |
+-------+
1 row in set (0.00 sec)
如果再设定character_set_client，效果和只设定character_set_results没有什么差别
mysql> set character_set_client='gbk';
Query OK, 0 rows affected (0.00 sec)
mysql> select * from ad;
+-------+
| name |
+-------+
| ??×? |
+-------+
1 row in set (0.00 sec)
mysql> select * from ad2;
+-------+
| name |
+-------+
| ??×? |
+-------+
1 row in set (0.00 sec)
mysql> create table ad3(name varchar(32));
Query OK, 0 rows affected (0.05 sec)
mysql> insert into ad3 values('汉字');
Query OK, 1 row affected (0.00 sec)
mysql> select * from ad3;
+------+
| name |
+------+
| ?? |
+------+
1 row in set (0.01 sec)
mysql> SHOW VARIABLES LIKE 'character_set%';
+--------------------------+---------------------------+
| Variable_name | Value |
+--------------------------+---------------------------+
| character_set_client | gbk |
| character_set_connection | latin1 |
| character_set_database | gbk |
| character_set_results | gbk |
| character_set_server | gbk |
| character_set_system | utf8 |
| character_sets_dir | D:mysql5sharecharsets |
+--------------------------+---------------------------+
7 rows in set (0.00 sec)
如果再设定character_set_connection，不影响已经建立和插入的表，但是新建立、插入汉字的表就能正确显示
mysql> set character_set_connection='gbk';
Query OK, 0 rows affected (0.00 sec)
mysql> select * from ad3;
+------+
| name |
+------+
| ?? |
+------+
1 row in set (0.00 sec)
mysql> select * from ad2;
+-------+
| name |
+-------+
| ??×? |
+-------+
1 row in set (0.00 sec)
mysql> select * from ad;
+-------+
| name |
+-------+
| ??×? |
+-------+
1 row in set (0.00 sec)
我们可以查看各个表的字符集
mysql> show create table ad;
+-------+----------------------------------------------------------------------------------------------+
| Table | Create Table |
+-------+----------------------------------------------------------------------------------------------+
| ad | CREATE TABLE `ad` (
`name` varchar(32) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 |
+-------+----------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)
mysql> show create table ad2;
+-------+--------------------------------------------------------------------------------------------+
| Table | Create Table |
+-------+--------------------------------------------------------------------------------------------+
| ad2 | CREATE TABLE `ad2` (
`name` varchar(32) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=gbk |
+-------+--------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)
mysql> show create table ad3;
+-------+--------------------------------------------------------------------------------------------+
| Table | Create Table |
+-------+--------------------------------------------------------------------------------------------+
| ad3 | CREATE TABLE `ad3` (
`name` varchar(32) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=gbk |
+-------+--------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)
此时新建的表、此时插入汉字，显示就正确了
mysql> set character_set_client=gbk;
Query OK, 0 rows affected (0.00 sec)
mysql> set character_set_connection=gbk;
Query OK, 0 rows affected (0.00 sec)
mysql> set character_set_results=gbk;
Query OK, 0 rows affected (0.00 sec)
mysql> create table ad4(name varchar(32));
Query OK, 0 rows affected (0.06 sec)
mysql> insert into ad4 values('汉字');
Query OK, 1 row affected (0.00 sec)
mysql> select * from ad;
+-------+
| name |
+-------+
| ??×? |
+-------+
1 row in set (0.00 sec)
mysql> select * from ad4;
+------+
| name |
+------+
| 汉字 |
+------+
1 row in set (0.00 sec)
mysql> create table ad5(name varchar(32)) DEFAULT CHARSET=gbk;
Query OK, 0 rows affected (0.10 sec)
mysql> insert into ad5 values('汉字');
Query OK, 1 row affected (0.00 sec)
mysql> select * from ad5;
+------+
| name |
+------+
| 汉字 |
+------+
1 row in set (0.00 sec)
mysql> select * from ad4;
+------+
| name |
+------+
| 汉字 |
+------+
1 row in set (0.00 sec)
mysql> show create table ad4;
+-------+--------------------------------------------------------------------------------------------+
| Table | Create Table |
+-------+--------------------------------------------------------------------------------------------+
| ad4 | CREATE TABLE `ad4` (
`name` varchar(32) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=gbk |
+-------+--------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)
mysql> show create table ad5;
+-------+--------------------------------------------------------------------------------------------+
| Table | Create Table |
+-------+--------------------------------------------------------------------------------------------+
| ad5 | CREATE TABLE `ad5` (
`name` varchar(32) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=gbk |
+-------+--------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)
mysql> show create table ad3;
+-------+--------------------------------------------------------------------------------------------+
| Table | Create Table |
+-------+--------------------------------------------------------------------------------------------+
| ad3 | CREATE TABLE `ad3` (
`name` varchar(32) default NULL
) ENGINE=MyISAM DEFAULT CHARSET=gbk |
+-------+--------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)
mysql> exit
Bye
分享到：
发表评论
-
MYSQL ERROR CODE
2012-04-14 00:51 11431005：创建表失败 1006： ... -
mysql: logs-slave-updates备忘
2011-10-30 01:02 1314--logs-slave-updates 通常情 ... -
MYSQL常用命令
2011-10-30 02:33 776启动：net start mySql; 进入：mysql ... -
使用mysqldump备份数据库
2011-10-29 17:28 1370mysqldump 是采用SQL级别的备份机制，它将数据表 ... -
MYSQL CLUSTER
2011-10-29 17:26 865一、介绍 这篇文档旨在介绍如何安装配置基于2台服务器的My ... -
Mysql主从复制配置（2）
2011-10-29 07:59 1358Mysql主从复制是一台服务器充当主服务器，另一台或多台服务器 ... -
Linux下的MySQL主从同步
2011-10-29 05:38 1318一、测试环境： 主库 ... -
MySQL数据库备份和还原的常用命令
2011-10-29 05:15 783备份MySQL数据库的命令 mysqldump -h ... -
Mysql5.5.10互为主从复制配置
2011-10-28 23:26 1339MySQL-master1：192.168.0.128 My ... -
MySQL各种存储引擎简介与选择
2011-05-23 16:17 864MySQL有多种存储引擎：My ...
相关推荐
Ubuntu 11.10 MySQL客户端Emma 6.0中文乱码解决办法.docx
mysql客户端mysql客户端mysql客户端
mysql mysql客户端 工具 客户端
MySQL客户端工具，版权归原来的公司所有，为方便大家学习使用，不要用于商业用途
非常好用的mysql客户端sqlyog中文版，64位Windows版；
MYSQL客户端MYSQL客户端MYSQL客户端MYSQL客户端MYSQL客户端
SQLyog_Enterprise.rar 为mysql的客户端，简单轻量，适合windows的各个版本
mysql数据库客户端工具，可视化工具，优秀的MySQL数据库图形界面！
绿色版mysql客户端，可以很好的感受mysql.
Mysql客户端命令 Mysql客户端命令 Mysql客户端命令 Mysql客户端命令 Mysql客户端命令
SQLyog 是一个易于使用的、快速而简洁的图形化管理MYSQL数据库的工具，它能够在任何地点有效地管理你的数据库。
MySQL 客户端MySQL-Front_Setup
Mysql客户端服务端安装包
mysql客户端程序mysql客户端程序mysql客户端程序mysql客户端程序mysql客户端程序mysql客户端程序mysql客户端程序mysql客户端程序mysql客户端程序mysql客户端程序mysql客户端程序mysql客户端程序mysql客户端程序mysql...
好工具 事倍功半 推荐使用这款MySQL客户端工具 ！好工具 事倍功半 推荐使用这款MySQL客户端工具 ！
解决MySQL数据库乱码问题，以及命令行查表乱码问题
mysql客户端开发程序,中文版软件.很适合开发.
mysql客户端开发工具 Navicat，zip格式
sqlyog工具 mysql客户端连接 好用