为什么mysql默认为utf-8,但是CMD不能插入汉字
来源:互联网 发布:网络66是什么意思 编辑:程序博客网 时间:2024/05/19 19:40
我的mysql数据库状态如下:
--------------
D:Program FilesMySQLMySQL Server5.2binmysql.exe Ver 14.13 Distrib 5.2.0-f
alcon-alpha, for Win32 (ia32)
Connection id:
Current database:
Current user:
SSL:
Using delimiter:
Server version:
GPL)
Protocol version:
Connection:
Servercharacterset:
Db
Clientcharacterset:
Conn.characterset:
TCP port:
Uptime:
Threads: 1 Questions: 230 Slow queries: 0 Opens:25 Flush tables: 1 Open ta
bles: 1 Queries per second avg:%
--------------
无论我用jsp页面还是servlet(而且统一为utf-8)向数据库插入中文时出现乱码,显示为:???,在cmd界面插入中文数据时出现ERROR:1366(HY000)Incorrectstring value:,我google了很久,试了很多种方法都没用,只有一个地方说的方法有效。就是将MySQL Server5.2中的my.ini中的CLIENT SECTION部分中的default-character-set=utf-8改为default-character-set=GBK,其他的都不变,然后重新打开mysql的cmd界面执行插入操作就ok了。
没改之前的my.ini为:
# MySQL Server Instance ConfigurationFile
#----------------------------------------------------------------------
... ...
# CLIENT SECTION
#----------------------------------------------------------------------
#
# The following options will be read by MySQLclient applications.
# Note that only client applications shipped byMySQL are guaranteed
# to read this section. If you want your ownMySQL client program to
# honor these values, you need to specify it asan option during the
# MySQL client libraryinitialization.
#
[client]
port=3306
[mysql]
default-character-set=utf8
# SERVER SECTION
#----------------------------------------------------------------------
... ...
改了之后为:
# MySQL Server Instance ConfigurationFile
#----------------------------------------------------------------------
... ...
# CLIENT SECTION
#----------------------------------------------------------------------
#
# The following options will be read by MySQLclient applications.
# Note that only client applications shipped byMySQL are guaranteed
# to read this section. If you want your ownMySQL client program to
# honor these values, you need to specify it asan option during the
# MySQL client libraryinitialization.
#
[client]
port=3306
[mysql]
default-character-set=GBK
# SERVER SECTION
#----------------------------------------------------------------------
... ...
网络上很多高手都说要jsp、servlet、mysql的编码要统一,但是统一为utf-8却会出现问题,只有这样改了才ok,至于到底原因在还请高手们多多指教。
- 为什么mysql默认为utf-8,但是CMD不能插入汉字
- 如何设置eclipse默认编码为utf-8和MySql数据库插入乱码
- MySQL改变默认编码为utf-8
- mysql中设置默认字符编码为utf-8
- Debian下设置MySQL默认编码为UTF-8
- mysql修改默认的环境的字符集为utf-8
- 通过my.ini修改mysql默认编码为UTF-8
- WampServer中修改MySQL默认编码为utf-8
- Mac上设置MySQL默认编码为UTF-8
- mac 永久设置mysql的默认字符集为utf-8
- Linux mysql修改默认字符集永久为UTF-8
- MySql即使所有地方的编码格式都为utf-8时,为何还是不能正常输入和在cmd下显示
- cmd不能输入汉字
- 修改mysql默认字符集为utf
- CMD显示乱码,更改为UTF-8
- 改变cmd编码格式为utf-8
- mysql 插入utf-8字符
- MySql5.5 在安装时设置编码为utf-8,扔不能插入中文的问题解决
- Linux设备驱动调试
- 转《一个电子工程师的经验之谈》
- 【rmzt】绿色&&地球win7主题_7.14
- UINavigationController
- discuz运营的一些资料
- 为什么mysql默认为utf-8,但是CMD不能插入汉字
- change kernel defconfig
- wpf 分别用前台和后台 两种方法 绘制矩形 填充
- 编程之道
- Hibernate批处理操作优化 (批量插入、更新与删除)
- 第二天
- ios中关于delegate(委托)的使用心得
- 最好用(个人认为)的C++单例模式的实现
- Windows如何在cmd命令行中查看、修改、删除与添加、设置环境变量