我有一个PHP程序,数据库用到的是GBK编码,但是在FressBSD服务器上只支持UTF-8编码,我导入数据就提示MySQL Server Error:Unknown character set: 'gbk' 而如果把数据库编码改为UTF-8的话,程序就会出现错误注:我在网上搜索的解决方法cd /usr/ports/databases/mysql51-server
make WITH_CHARSET=gbk WITH_XCHARSET=all WITH_COLLATION=gbk_chinese_ci BUILD_STATIC=yes install clean但是运行时出错!提示:
mysql-server-5.1.30 cannot install: MySQL versions mismatch: mysql50-client is installed and wanted version is mysql51-client.
*** Error code 1,现在要怎么办啊???哪们大哥帮帮忙啊
make WITH_CHARSET=gbk WITH_XCHARSET=all WITH_COLLATION=gbk_chinese_ci BUILD_STATIC=yes install clean但是运行时出错!提示:
mysql-server-5.1.30 cannot install: MySQL versions mismatch: mysql50-client is installed and wanted version is mysql51-client.
*** Error code 1,现在要怎么办啊???哪们大哥帮帮忙啊
mysql-server-5.1.30 cannot install: MySQL versions mismatch: mysql50-client is installed and wanted version is mysql51-client.
*** Error code 1
----------------------------------------
看来你要删除你的mysql client重新安装一个5.1的删除用
shell>find -name mysql
shell>find -name mysqld
找到文件全部删除
如果是rpm包安装的
shell>rpm -e -nodeps mysql
9.4. Adding a New Character Set不过没试过。
告诉你方法吧,装完还要配置my.cnf的,但是FreeBSD下默认没有,必须自己拷贝一下,命令如下
cp /usr/local/share/mysq/mysql-large.cnf /usr/local/etc/my.cnf
然后把default-character-set=gbk加到my.cnf的[mysqld]下面就可以了
/usr/local/etc/rc.d/mysql-server restart