mysql的字符集问题

Question

执行存储过程的时候，报个错执行不下去了。
1267 illegal mix of collations (gbk_chinese_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation '='但是我库里面都已经改成gb2312的字符集了。但是还是报这个错，不知道哪里还有latin1的了。求哪位大侠指点一下？
+--------------------------+----------------------------+
| Variable_name            | Value                      |
+--------------------------+----------------------------+
| character_set_client     | gb2312                     |
| character_set_connection | gb2312                     |
| character_set_database   | gb2312                     |
| character_set_filesystem | binary                     |
| character_set_results    | gb2312                     |
| character_set_server     | gb2312                     |
| character_set_system     | utf8                       |
| character_sets_dir       | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+
+----------------------+-------------------+
| Variable_name        | Value             |
+----------------------+-------------------+
| collation_connection | gb2312_chinese_ci |
| collation_database   | gb2312_chinese_ci |
| collation_server     | gb2312_chinese_ci |
+----------------------+-------------------+

Answer 1

贴出你的语句和相关表的信息。http://blog.csdn.net/ACMAIN_CHM/archive/2009/05/12/4174186.aspx
MySQL 中文显示乱码