[mythtv-users] Updating Database scheme screws up my Collation

[James Buckley]

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