[mythtv-users] Updating Database scheme screws up my Collation
James Buckley
james at logicland.co.uk
Sun Jun 4 18:18:18 UTC 2006
The schema update shouldn't run every time a myth program runs. It only runs
once for me (or maybe twice, does it when I first run mythtv-setup, and then
mythfrontend)
-----Original Message-----
From: mythtv-users-bounces at mythtv.org
[mailto:mythtv-users-bounces at mythtv.org] On Behalf Of Adam Findley
Sent: 04 June 2006 06:43
To: Discussion about mythtv
Subject: [mythtv-users] Updating Database scheme screws up my Collation
Hey all,
I am having issues with mythtv's schema update (which happens to be run
anytime any myth program is run). When the schema updates, it sets my
collation from general_ci to swedish_ci. Then when any updates to the
database occur through mythfilldatabase, it can't update because it says:
Illegal mix of collations (latin1_swedish_ci, IMPLICIT) and
(latin1_general_ci, IMPLICIT) for operation =.
It only modifies my database (mythconverg) collition though, not each
individual table's collition (hence the problem). Any ideas on how to
fix this? I can fix it by hand, but it's really annoying to do it every
time you open start a myth program.
Adam
_______________________________________________
mythtv-users mailing list
mythtv-users at mythtv.org
http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
___________________________________________________________
$0 Web Hosting with up to 200MB web space, 1000 MB Transfer
10 Personalized POP and Web E-mail Accounts, and much more.
Signup at www.doteasy.com
More information about the mythtv-users
mailing list