Hi... I am not sure if this might be a bug inside mythtv: I have a gentoo installation and tried to edit a record rule today and there was a german umlaut in the record rule. After pressing test, I received the error message: "illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation 'like'". I tried the sql command which mythfrontend supplied together with this error message inside "mysql" on the console: mysql> SELECT NULL FROM (program,channel) WHERE program.title LIKE 'Ein Fall f
Hi... I am not sure if this might be a bug inside mythtv: I have a gentoo installation and tried to edit a record rule today and there was a german umlaut in the record rule. After pressing test, I received the error message: "illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation 'like'". I tried the sql command which mythfrontend supplied together with this error message inside "mysql" on the console: mysql> SELECT NULL FROM (program,channel) WHERE program.title LIKE 'Ein Fall für den Fuchs: %'; ERROR 1267 (HY000): Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation 'like' But then I changed the setting inside /etc/my.cnf: I changed the default-character-set from utf8 to latin1 within the [mysql] section. Then mysql did NOT complain anymore! But mythfrontend still does?! Is this a bug inside mythfrontend in the way it contacts the database or is it another setting inside my.cnf that is misssing?! Greetings, tormen.
Sorry I forgot: * dev-db/mysql Installed: 5.0.26-r1 * media-tv/mythtv Installed: 0.20_p11626 tormen.
...damn it... again ;-) I compiled the mysql database with "-latin1". Afterwards I installed mythtv in the above mentioned version and began to use it for the first time. The my.cnf is the original one from the gentoo package, except the changed default-char-set as described before. phpmyadmin/ shows me that the collation for the mythconverg database is latin1_swedish_ci (the default collation for latin1 charset as mysql.com told me). Greetings, tormen.
Uhm... closing.