我的升级到mysql5.0后，页面显示全是？？问号.

原来安装用的是gb2312编码，数据库升级到mysql5.0后,导致页面显示全是？？问号，登录后，区块管理部分还无法显示。打开php查错模式
发现getAllByGroupModule()函数内部产生的sql语句执行错误。
把产生的sql语句拿到mysql> 下执行，报告数据库引擎执行错误。

结果按照网上的贴子，重新编译mysql5.0源码，
./configure --with-charset=gbk --with-collation=gbk_chinese_ci --with-extra-charsets=gb2312,big5,utf8,binary,ascii

--prefix=/usr/local/mysql
make
make install
cp support-files/my-medium.cnf /etc/my.cnf
cd /usr/local/mysql
bin/mysql_install_db --user=mysql
chown -R root .
chown -R mysql var
chgrp -R mysql .
bin/mysqld_safe --user=mysql &
bin/mysql
mysql> show variables;

默认数据库端使用gbk
Server version: 5.0.51a-log Source distribution
Protocol version: 10
Connection: Localhost via UNIX socket
Server characterset: gbk
Db characterset: gbk
Client characterset: gbk
Conn. characterset: gbk
UNIX socket: /tmp/mysql.sock

但是导致所有的区块都无法显示，所有用户也无法登录

因此也无法用管理员用户登录开启php查错模式。

查看日志 /var/log/mysql/mysql.err 是如下错误
080325 10:39:50 mysqld started
080325 10:39:50 InnoDB: Started; log sequence number 0 43655
080325 10:39:50 [Note] /usr/local/mysql/libexec/mysqld: ready for connections.
Version: '5.0.51a-log' socket: '/tmp/mysql.sock' port: 3306 Source distribution
080325 10:39:58 [Warning] './xoops/xoops_config' had no or invalid character set, and default character set is multi-byte, so character column sizes may have changed
080325 10:39:58 [Warning] './xoops/xoops_session' had no or invalid character set, and default character set is multi-byte, so character column sizes may have changed
080325 10:39:58 [Warning] './xoops/xoops_modules' had no or invalid character set, and default character set is multi-byte, so character column sizes may have changed
080325 10:39:58 [Warning] './xoops/xoops_group_permission' had no or invalid character set, and default character set is multi-byte, so character column sizes may have changed
080325 10:39:58 [Warning] './xoops/xoops_banner' had no or invalid character set, and default character set is multi-byte, so character column sizes may have changed
080325 10:39:58 [Warning] './xoops/xoops_tplfile' had no or invalid character set, and default character set is multi-byte, so character column sizes may have changed


有没有碰到过类似问题的兄弟，给个完整的解决办法！！！

已搞定

怎么搞定的？

用最笨的办法，下载了一个mysql-4.0.26的源码。
重新编译。字符集部分看源码内的INSTALL-SOURCE文档有说明.

mysql5.0官方的源码试过，也不管用，�<埔院蟀沧皒oops还是utf8的保险些。

搞不懂postgresql的版本兼容性一般都没问题，mysql官方就没有考虑到
这一点吗? 这个编码问题导致了xoops内部核心生成的sql语句都无法执行， 还有一系列的连锁错误。

引文：

我的也是啊
真郁闷
不知道该怎么解决啊
还有我数据库里面没乱吗啊
就显示的时候是乱吗?

引文：

你这个还是没有根本解决，迟早数据库还得升到5.0

编译时，用with-charset=utf8 with-xcharset=all 试试

数据导入时，加上 with--default-character-set=utf8试试