怎样往MYSQL输入汉字?

来源:百度知道 编辑:UC知道 时间:2024/05/22 00:26:50
我是一数据库白痴,我用INSERT语句往MYSQL里输入汉字,可怎么也输不进去,我用的是CHAR(*)格式,有人说用GB格式,可GB格式怎么用,具体该怎么输,比如我先前输Name char(8),那我现在该怎么输?
知道的回答下,谢谢了!

有两种方法...你试一下...不行的话加我的QQ 76558882

1. 修改 mysql 安装目录下的 my.ini
修改 default-character-set=latin1
把latin1 改为 gb2312 或 gbk 注意: 修改两处
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=latin1 //把 latin1 改为 gb2312或 gbk

# SERVER SECTION
# ----------------------------------------------------------------------
#
# The following options will be read by the MySQL Server. Make sure that
# you have installed the server correctly (see above) so it read