mysql数据库安装的时候选择了utf8的编码,但是在cmd界面插入中文数据时,总是出现ERROR:1366(HY000)Incorrect string value 这样的错误 。
----------------------------------------------------------------------------------------------
我google了很久,试了很多种方法都没用,只有一个地方说的方法有效。就是将MySQL Server 5.2中的my.ini中的CLIENT SECTION部分中的default-character-set=utf-8改为default-character-set=GBK,其他的都不变,然后重新打开mysql的cmd界面执行插入操作就ok了。
没改之前的my.ini为:
# MySQL Server Instance Configuration File
# ----------------------------------------------------------------------
... ...
# CLIENT SECTION
# ----------------------------------------------------------------------
#
# The following options will be read by MySQL client applications.
# Note that only client applications shipped by MySQL are guaranteed
# to read this section. If you want your own MySQL client program to
# honor these values, you need to specify it as an option during the
# MySQL client library initialization.
#
[client]
port=3306
[mysql]
default-character-set=utf8
# SERVER SECTION
# ----------------------------------------------------------------------
... ...
改了之后为:
# MySQL Server Instance Configuration File
# ----------------------------------------------------------------------
... ...
# CLIENT SECTION
# ----------------------------------------------------------------------
#
# The following options will be read by MySQL client applications.
# Note that only client applications shipped by MySQL are guaranteed
# to read this section. If you want your own MySQL client program to
# honor these values, you need to specify it as an option during the
# MySQL client library initialization.
#
[client]
port=3306
[mysql]
default-character-set=GBK
# SERVER SECTION
# ----------------------------------------------------------------------
分享到:
相关推荐
linux下设置mysql字符集为UTF-8以及mysql重启
mysql57驱动jar包mysql-connector-java-5.1.49 mysql57驱动jar包mysql-connector-java-5.1.49 mysql57驱动jar包mysql-connector-java-5.1.49 mysql57驱动jar包mysql-connector-java-5.1.49 mysql57驱动jar包mysql-...
开发工具 mysql-connector-java-5.1.40-bin开发工具 mysql-connector-java-5.1.40-bin开发工具 mysql-connector-java-5.1.40-bin开发工具 mysql-connector-java-5.1.40-bin开发工具 mysql-connector-java-5.1.40-bin...
mysql-installer-community-5.7.31.0 mysql-installer-community-5.7.31.0 mysql-installer-community-5.7.31.0 mysql-installer-community-5.7.31.0 mysql-installer-community-5.7.31.0 mysql-installer-community...
赠送jar包:mysql-binlog-connector-java-0.21.0.jar; 赠送原API文档:mysql-binlog-connector-java-0.21.0-javadoc.jar; 赠送源代码:mysql-binlog-connector-java-0.21.0-sources.jar; 赠送Maven依赖信息文件:...
JavaEE源代码 mysql-connector-java-5.0.8-binJavaEE源代码 mysql-connector-java-5.0.8-binJavaEE源代码 mysql-connector-java-5.0.8-binJavaEE源代码 mysql-connector-java-5.0.8-binJavaEE源代码 mysql-connector...
mysql-connector-net-0.1.0.msi mysql-connector-net-6.3.6.msi mysql-connector-net-6.3.7.msi mysql-connector-net-6.3.8.msi mysql-connector-net-6.3.9.msi mysql-connector-net-6.4.0.msi mysql-connector-...
mysql-connector-java-8.0.27 jar包 mysql-connector-java-8.0.27 jar包 mysql-connector-java-8.0.27 jar包 mysql-connector-java-8.0.27 jar包 mysql-connector-java-8.0.27 jar包 mysql-connector-java-8.0.27 ...
正因此,才造就了MySQL中的UTF-8与我们日常开发中的UTF-8不一致,从到导致了些问题。MySQL的UTF-8只支持每个字符最多三个字节,而真正的 UTF-8 是每个字符最多四个字节。 问题复现 有数据库表如下:utf8编码方式 ...
mysql-connector-java-5.1.27.jar mysql-connector-java-5.1.27.jar
Java支持mysql8.0x的jdbc驱动和c3p0库,包含如下三个jar包 c3p0-0.9.5.2.jar mchange-commons-java-0.2.15.jar mysql-connector-java-8.0.12.jar...characterEncoding=UTF-8&useSSL=false&serverTimezone=GMT+8
mysql数据库连接 mysql-connector-java-5.1.26-bin.jar
包含mysql-connector-java-8.0.22.jar包含mysql-connector-java-8.0.22.jar包含mysql-connector-java-8.0.22.jar包含mysql-connector-java-8.0.22.jar包含mysql-connector-java-8.0.22.jar包含mysql-connector-java-...
mysql驱动包 mysql-connector-java-5.1.13-bin.jar 方便快捷获取。。。
下面小编就为大家带来一篇全面了解mysql中utf8和utf8mb4的区别。小编觉得挺不错的,现在就分享给大家,也给大家做个参考。一起跟随小编过来看看吧
mysql-connector-java-5.1.7-bin.jar
包括以下文件 mysql-connector-java-3.0.16-ga-bin.jar mysql-connector-java-3.1.8-bin.jar mysql-connector-java-3.1.13-bin.jar mysql-connector-java-5.0.5-bin.jar
Mysql数据库驱动mysql-connector-java-5.1.41-bin.jar
jdk-8u131-linux-x64.tar.gz 2\把安装包上传到linux服务器上 \root 3\首先确认一下你的linux服务器上面是否有安装过jdk rpm -qa|grep java rpm -qa|grep jdk 如果查询到已经安装过jdk就卸载 java rpm -e ...
mysql-connector-java mysql-connector-java-5.1.5 mysql-connector-java-5.1.40