1.将WEB-INF/config/jforum-custom.conf ,/WEB-INF/config/database/mysql/mysql.properties的database.connection.string加上&useUnicode=true&characterEncoding=utf8,数据库编码为utf-8,环境是
JDK1.4
MYSQL5.0.24
JFORUM2.1.6
不过搜索还是不能起作用,学习中,找到方法再补上来.
JFORUM的作者Rafael Steil 说I can only get it working with mysql 4.0.x - newer versions don't work very well.
只能在MYSQL4.0.X的版本上很好的工作,其他版本估计大多都是字符集的问题.
MySQL 4.1的字符集支持(Character Set Support)有两个方面:字符集(Character set)和排序方式(Collation)。对于字符集的支持细化到四个层次: 服务器(server),数据库(database),数据表(table)和连接(connection)。
查看系统的字符集和排序方式的设定可以通过下面的两条命令:
mysql> SHOW VARIABLES LIKE 'character_set_%';
+--------------------------+----------------------------+
| Variable_name | Value |
+--------------------------+----------------------------+
| character_set_client | latin1 |
| character_set_connection | latin1 |
| character_set_database | latin1 |
| character_set_results | latin1 |
| character_set_server | latin1 |
| character_set_system | utf8 |
| character_sets_dir | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+
有什么好的方法请告诉我,谢谢!
QQ:56355337