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

Adam Findley adam at cs.byu.edu
Mon Jun 5 00:38:29 UTC 2006


> The only thing run by dbcheck that I see that might be related is:
> 
> ALTER DATABASE mythconverg DEFAULT CHARACTER SET latin1;
 > http://www.gossamer-threads.com/lists/mythtv/commits/181541#181541
 > http://www.gossamer-threads.com/lists/mythtv/commits/175938#175938

That (and both of those links) looks like what is causing the problem. 
It changes the database from latin_general_c1 to latin_swedish_c1, then 
it runs into issues later.

> If so, the database is created as latin1 
> unless you've made some changes since creation, everything should line 
> up, right?
Hence the reason why I am confused.  Any ideas on how to make this work?

Adam


More information about the mythtv-users mailing list