［求助］数据转换之后后台出现了问题

　　我转换了数据之后，后台经常出现

Discuz! info: MySQL Query Error

User: 珠珠
Time: 2007-1-22 10:08pm
Script: /admincp.php

SQL: SELECT a.id, a.author, a.message, m.uid AS authorid, a.subject, a.redirect, a.starttime FROM cdb_announcements a LEFT JOIN cdb_members m ON m.username=a.author WHERE a.starttime<='1169474901' ORDER BY a.displayorder, a.starttime DESC, a.id DESC LIMIT 1
Error: Illegal mix of collations (gb2312_chinese_ci,IMPLICIT) and (gbk_chinese_ci,IMPLICIT) for operation '='
Errno.: 1267

Similar error report has beed dispatched to administrator before.


我想请问是怎么回事？

phpmyadnin里你的数据库字符集设置为gbk
选gbk_chinese_ci
不要选gb2312_chinese_ci
然后重新再导入数据即可