日期:2014-05-16  浏览次数:20677 次

mysql默认为utf-8,但是CMD却不能插入中文

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

# ----------------------------------

?