czjin 写了:我使用一台openbsd有两年时间，mysql默认是utf8，不支持GBK和gb2312，怎样才能添加使它支持GBK和gb2312呢？我在#/usr/ports/databases/mysql下执行了#make WITH_CHARSET=GBK WITH_CHARSET=gb2312 经过长时间编译，编译中间也没报错，用mysql> show charset; 但是结果还是不支持。怎样才能添加进去呢？请各位高手给我帮助谢谢
代码: 全选
.......
CONFIGURE_ARGS+= --localstatedir="${DB_DIR}" \
--with-big-tables \
--with-comment='OpenBSD port: ${FULLPKGNAME-server}' \
--with-libwrap \
--with-low-memory \
--with-mysqld-user="_mysql" \
--with-plugins=max-no-ndb \
--with-ssl=/usr \
--with-unix-socket-path="${SOCKET_DIR}/mysql.sock" \
--without-docs \
--without-readline \
[color="Red"] --with-charset="gbk" \
--with-charset="gb2312" \[/color]
.....
代码: 全选
# make install-all clean代码: 全选
# mysql -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.1.60-log OpenBSD port: mysql-server-5.1.60
Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> show char set;
+----------+-----------------------------+---------------------+--------+
| Charset | Description | Default collation | Maxlen |
+----------+-----------------------------+---------------------+--------+
| dec8 | DEC West European | dec8_swedish_ci | 1 |
| cp850 | DOS West European | cp850_general_ci | 1 |
| hp8 | HP West European | hp8_english_ci | 1 |
| koi8r | KOI8-R Relcom Russian | koi8r_general_ci | 1 |
| latin1 | cp1252 West European | latin1_swedish_ci | 1 |
| latin2 | ISO 8859-2 Central European | latin2_general_ci | 1 |
| swe7 | 7bit Swedish | swe7_swedish_ci | 1 |
| ascii | US ASCII | ascii_general_ci | 1 |
| hebrew | ISO 8859-8 Hebrew | hebrew_general_ci | 1 |
| koi8u | KOI8-U Ukrainian | koi8u_general_ci | 1 |
[color="Red"][B]| gb2312 | GB2312 Simplified Chinese | gb2312_chinese_ci | 2 |[/B][/color]
| greek | ISO 8859-7 Greek | greek_general_ci | 1 |
| cp1250 | Windows Central European | cp1250_general_ci | 1 |
| latin5 | ISO 8859-9 Turkish | latin5_turkish_ci | 1 |
| armscii8 | ARMSCII-8 Armenian | armscii8_general_ci | 1 |
| utf8 | UTF-8 Unicode | utf8_general_ci | 3 |
| cp866 | DOS Russian | cp866_general_ci | 1 |
| keybcs2 | DOS Kamenicky Czech-Slovak | keybcs2_general_ci | 1 |
| macce | Mac Central European | macce_general_ci | 1 |
| macroman | Mac West European | macroman_general_ci | 1 |
| cp852 | DOS Central European | cp852_general_ci | 1 |
| latin7 | ISO 8859-13 Baltic | latin7_general_ci | 1 |
| cp1251 | Windows Cyrillic | cp1251_general_ci | 1 |
| cp1256 | Windows Arabic | cp1256_general_ci | 1 |
| cp1257 | Windows Baltic | cp1257_general_ci | 1 |
| binary | Binary pseudo charset | binary | 1 |
| geostd8 | GEOSTD8 Georgian | geostd8_general_ci | 1 |
+----------+-----------------------------+---------------------+--------+
27 rows in set (0.00 sec)
mysql> 代码: 全选
....
[client]
default-character-set=gbk
...
[mysqld]
default-character-set=gbk
...
代码: 全选
mysql> show char set;
+----------+-----------------------------+---------------------+--------+
| Charset | Description | Default collation | Maxlen |
+----------+-----------------------------+---------------------+--------+
| dec8 | DEC West European | dec8_swedish_ci | 1 |
| cp850 | DOS West European | cp850_general_ci | 1 |
| hp8 | HP West European | hp8_english_ci | 1 |
| koi8r | KOI8-R Relcom Russian | koi8r_general_ci | 1 |
| latin1 | cp1252 West European | latin1_swedish_ci | 1 |
| latin2 | ISO 8859-2 Central European | latin2_general_ci | 1 |
| swe7 | 7bit Swedish | swe7_swedish_ci | 1 |
| ascii | US ASCII | ascii_general_ci | 1 |
| hebrew | ISO 8859-8 Hebrew | hebrew_general_ci | 1 |
| koi8u | KOI8-U Ukrainian | koi8u_general_ci | 1 |
| greek | ISO 8859-7 Greek | greek_general_ci | 1 |
| cp1250 | Windows Central European | cp1250_general_ci | 1 |
[color="Red"]| gbk | GBK Simplified Chinese | gbk_chinese_ci | 2 |[/color]
| latin5 | ISO 8859-9 Turkish | latin5_turkish_ci | 1 |
| armscii8 | ARMSCII-8 Armenian | armscii8_general_ci | 1 |
| utf8 | UTF-8 Unicode | utf8_general_ci | 3 |
| cp866 | DOS Russian | cp866_general_ci | 1 |
| keybcs2 | DOS Kamenicky Czech-Slovak | keybcs2_general_ci | 1 |
| macce | Mac Central European | macce_general_ci | 1 |
| macroman | Mac West European | macroman_general_ci | 1 |
| cp852 | DOS Central European | cp852_general_ci | 1 |
| latin7 | ISO 8859-13 Baltic | latin7_general_ci | 1 |
| cp1251 | Windows Cyrillic | cp1251_general_ci | 1 |
| cp1256 | Windows Arabic | cp1256_general_ci | 1 |
| cp1257 | Windows Baltic | cp1257_general_ci | 1 |
| binary | Binary pseudo charset | binary | 1 |
| geostd8 | GEOSTD8 Georgian | geostd8_general_ci | 1 |
+----------+-----------------------------+---------------------+--------+
27 rows in set (0.01 sec)代码: 全选
# pkg_info
autoconf-2.63 automatically configure source code on many Un*x platforms
bzip2-1.0.6 block-sorting file compressor, unencumbered
curl-7.23.1 get files from FTP, Gopher, HTTP or HTTPS servers
ddclient-3.8.0p3 Dynamic DNS service update client
femail-0.97p1 simple SMTP client
femail-chroot-0.97p3 simple SMTP client for chrooted apache
gettext-0.18.1p0 GNU gettext
groff-1.21p6 GNU troff typesetter
help2man-1.29p0 GNU help2man
jpeg-8c IJG's JPEG compression utilities
libgcrypt-1.4.6p1 crypto library based on code used in GnuPG
libgpg-error-1.10 error codes for GnuPG related software
libiconv-1.14 character set conversion library
libidn-1.22 internationalized string handling
libltdl-2.4.2 GNU libtool system independent dlopen wrapper
libmcrypt-2.5.8p1 interface to access block/stream encryption algorithms
libxml-2.7.8p3 XML parsing library
libxslt-1.1.26p3 XSLT C Library for GNOME
metaauto-1.0 wrapper for gnu auto*
mysql-client-5.1.60 multithreaded SQL database (client)
mysql-server-5.1.60 multithreaded SQL database (server)
mysql-tests-5.1.60 multithreaded SQL database (regression test suite/benchmark)
p5-Clone-0.31p1 recursively copy Perl datatypes
p5-DBD-mysql-4.020 MySQL drivers for the Perl DBI
p5-DBI-1.616 unified perl interface for database access
p5-FreezeThaw-0.43p2 module for converting structures to strings and back
p5-IO-Socket-SSL-1.44 perl interface to SSL sockets
p5-MLDBM-2.04 store multi-level hash structure in single-level tied hash
p5-Net-Daemon-0.43p0 extension for portable daemons
p5-Net-SSLeay-1.38 perl module for using OpenSSL
p5-Params-Util-1.00p2 utility to make parameter checking easier
p5-PlRPC-0.2018p1 module for writing rpc servers and clients
p5-SQL-Statement-1.33 sql parsing and processing
php-5.3.8p0 server-side HTML-embedded scripting language
php-bz2-5.3.8p0 bzip2 compression extensions for php5
php-curl-5.3.8p0 curl URL library extensions for php5
php-gd-5.3.8p0 image manipulation extensions for php5
php-mcrypt-5.3.8p0 mcrypt encryption/decryption extensions for php5
php-mysql-5.3.8p0 mysql database access extensions for php5
php-mysqli-5.3.8p0 mysql database access extensions for php5
php-soap-5.3.8p0 SOAP functions for php5
php-xsl-5.3.8p0 XSL functions for php5
png-1.5.6 library for manipulating PNG images
t1lib-5.1.0p2 Type 1 rasterizer library for UNIX/X11
unzip-6.0p0 extract, list & test files in a ZIP archive代码: 全选
mysql> SHOW VARIABLES LIKE 'character_set_%';
+--------------------------+----------------------------------+
| Variable_name | Value |
+--------------------------+----------------------------------+
| character_set_client | gbk |
| character_set_connection | gbk |
| character_set_database | gbk |
| character_set_filesystem | binary |
| character_set_results | gbk |
| character_set_server | gbk |
| character_set_system | utf8 |
| character_sets_dir | /usr/local/share/mysql/charsets/ |
+--------------------------+----------------------------------+
8 rows in set (0.01 sec)
mysql> SHOW VARIABLES LIKE 'collation_%';
+----------------------+----------------+
| Variable_name | Value |
+----------------------+----------------+
| collation_connection | gbk_chinese_ci |
| collation_database | gbk_chinese_ci |
| collation_server | gbk_chinese_ci |
+----------------------+----------------+
3 rows in set (0.00 sec)
mysql> 我没有明白你的意思，什么是“已有UTF-8网页的系统里怎么添加把GBK添加进去“？你的意思是mysql里还有其它的UTF-8的数据库？czjin 写了:leo兄太牛了按照您的指点我已经使论坛正常显示了，检查了几个页面没有发现错误。当然我做测试用的是全新系统，全新安装，下面的问题就是要解决在已有utf8网页系统的里怎样把GBK添加进去，而且utf8和gbk互不影响，我原来都是用packages安装的，现在删除mysql再用ports装一遍行吗，那么多的依赖关系怎么办，还请leo兄指点，谢谢。
代码: 全选
....
[client]
default-character-set=[color="Red"][B]utf8[/B][/color]
...
[mysqld]
default-character-set=[B][color="red"]utf8[/color][/B]
...代码: 全选
# mysql -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.1.54-log OpenBSD port: mysql-server-5.1.54p6
Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL v2 license
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
mysql> CREATE DATABASE `gobsd` DEFAULT CHARACTER SET gbk COLLATE gbk_chinese_ci;
Query OK, 1 row affected (0.00 sec)
mysql> grant all on gobsd.* to leo@localhost identified by 'gobsd.org';
Query OK, 0 rows affected (0.01 sec)
mysql>quit代码: 全选
pkg_delete -q /var/db/pkg/*代码: 全选
socket = /var/run/mysql/mysql.sock代码: 全选
socket = /var/www/var/run/mysql/mysql.sock有些是经验，但不见得就没有问题，大家一起探讨。czjin 写了:是的，我是在#/etc/rc.conf里将httpd设置为“-u”运行的apache1.3。因为刚学openbsd时对chroot这个设置的概念很不好理解，而且出过好几次错误，所以就一直用“-u”了，好像也没出什么差错，这个设置“”和“-u”有区别吗？
上传附件图片的地方我已找到了，hosts我会改动测试告诉您的。
说真心话就这几天我在leo兄这里学到很多openbsd的知识，谢谢