try:
修改mysql的配置文件,将client section的字符集设成GB2312..
修改mysql的配置文件,将client section的字符集设成GB2312..
解决方案 »
- MySQL安全模式启动带来的权限问题
- DISTINCT 的 请教
- PHP+MYSQL 字符串匹配查询
- mysql5的视图有没有左连接或者右连接的功能??
- 2000 Server版 不能启动MYSQL 帮忙看看!
- 请问:linux下的MD5校验码是什么东东,在安装软件时如何使用?
- 请问:何处有下载mysql for windows?是否是免费的?
- mysql性能、压力测试
- 怎么生成虚拟表啊!~~··在线坐等!~··
- load data local 命令用api执行出错 vs2008
- PostgreSQL中文帮助
- 各位好!我要找一个MYSQL 的客户端进行备份服务器上的数据,那个MYSQL 的确良客户端好用一些呀??
mysql> show variables like "%char%";
+--------------------------+-------------------------------------------------------+
| Variable_name | Value
|
+--------------------------+-------------------------------------------------------+
| character_set_client | utf8
|
| character_set_connection | utf8
|
| character_set_database | utf8
|
| character_set_results | utf8
|
| character_set_server | utf8
|
| character_set_system | utf8
|
| character_sets_dir | C:\Program Files\MySQL\MySQL Server5.0s\hare\charsets\ |
+--------------------------+-------------------------------------------------------+
SET CHARACTER_SET_CLIENT = utf8;
SET CHARACTER_SET_CONNECTION = utf8;
SET CHARACTER_SET_DATABASE = utf8;
SET CHARACTER_SET_RESULTS = utf8;
SET CHARACTER_SET_SERVER = utf8;
SET COLLATION_CONNECTION = utf8_bin;
SET COLLATION_DATABASE = utf8_bin;
SET COLLATION_SERVER = utf8_bin;
其中utf8和utf8_bin可以替换成你所需要的字符集,应该注意的是:该字符集应与你在MySQL数据库配制向导中所选择的字符集一致。
1: 安装MySQL数据库时候就指定字符集合为gbk或者gb2312,只要数据库中显示正常中文字符的话,页面肯定显示正常,哪来这么多的转换,烦死了!!
2: 指定服务器的 编码 GBK 或者GB23123: 修改安装目录下的 初始化配置文件 my.ini# The TCP/IP Port the MySQL Server will listen on
port=3306
#Path to installation directory. All paths are usually resolved relative to this.
basedir="E:/MySQL5/"#Path to the database root
datadir="E:/MySQL5/Data/"# The default character set that will be used when a new schema or table is
# created and no character set is defined
default-character-set=latin1 换成 gbk 或者 gb2312# The default storage engine that will be used when create new tables when
default-storage-engine=INNODB
String newstr=new String(str.getBytes("8859_1"),"gb2312");
2:把你的数据库的字符集改为gb2312。