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

[Adam Findley]

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