Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

MySQL collation mix error

4 views
Skip to first unread message

j...@nospam.com

unread,
Nov 11, 2009, 5:15:06 AM11/11/09
to
Hello,
I am experiencing this error with mysql 5.1.29rc:

Illegal mix of collations (utf8_bin,NONE) and
(utf8_general_ci,COERCIBLE) for operation 'like'

This happens only when I query the db from the web application, if I do
from the command line monitor it goes fine. These are my variables:

mysql> show variables like "%character%";
+--------------------------+----------------------------------------+
| Variable_name | Value |
+--------------------------+----------------------------------------+
| character_set_client | latin1 |
| character_set_connection | latin1 |
| character_set_database | latin1 |
| character_set_filesystem | binary |
| character_set_results | latin1 |
| character_set_server | latin1 |
| character_set_system | utf8 |
| character_sets_dir | /usr/local/mysql/share/mysql/charsets/ |
+--------------------------+----------------------------------------+

mysql> show variables like "%coll%";
+----------------------+-------------------+
| Variable_name | Value |
+----------------------+-------------------+
| collation_connection | latin1_swedish_ci |
| collation_database | latin1_swedish_ci |
| collation_server | latin1_swedish_ci |
+----------------------+-------------------+

Anybody can help?
Thanks
JM

0 new messages