[mythtv-users] Database error ("Illegal mix of collations ...etc")

[Eduard Huguet]

Hi,
   I'm just seeing that I have sometimes this error in
/var/log/mythtv/mythbackend.log:

2007-05-23 10:48:05.168 DB Error (Copy program data on record):
Query was:
REPLACE INTO recordedprogram SELECT * from program WHERE chanid = '1261' AND
starttime = '2007-05-23T10:00:00' AND title = 'Una vez mÆs';
Driver error was [2/1267]:
QMYSQL3: Unable to execute query
Database error was:
Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and
(utf8_general_ci,COERCIBLE) for operation '='


Does anybody know why this appear? I don't know what can this cause, if
anything. It seems like if a database update were failing due to different
text pages, but I haven't changed anything related to this (and even less to
'latin_swedish_ci', as my system is in spanish...).

Cheers
  Eduard
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mythtv.org/pipermail/mythtv-users/attachments/20070523/901ea693/attachment.htm