Encoding problems

Tarjei Huse <tarjei-y/[email protected]>
Newsgroups gmane.comp.web.midgard.devel
Message-ID <1138301108.5286.63.camel@localhost>
Hi, I get this error when trying out the latest and greatest midgard on
lampp:
midgard-core (pid:32722):(WARNING):  query failed: Illegal mix of
collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE)
for operation '='

I tried adding this under [mysqld], [client] and [mysql] in /etc/my.cnf:
default-character-set=utf8

I stil got the error. Then I did:
mysql midgard
show variables like 'coll%' ;
Now I get:
+----------------------+-------------------+
| Variable_name        | Value             |
+----------------------+-------------------+
| collation_connection | utf8_general_ci   |
| collation_database   | latin1_swedish_ci |
| collation_server     | utf8_general_ci   |
+----------------------+-------------------+

What should I do when this happens? I guess we'll se a few situations
like this one comming up.

Links/References:
http://forums.mysql.com/read.php?26,6528,15661
http://dev.mysql.com/doc/mysql/en/Charset-collation-charset.html
Tarjei

-- 
Tarjei Huse <tarjei-y/[email protected]>
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.