[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