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]>