[mythtv-users] Database update schema error with trunk utf8

[Michael T. Dean]

On 12/16/2008 11:11 PM, Michael T. Dean wrote:
> On 12/16/2008 08:21 PM, freedenizen wrote:
>   
>> On Tue, Dec 16, 2008 at 4:19 PM, Michael T. Dean wrote:
>>> What distro are you running?  Does the distro do stuff to help set up
>>> your database for you?
>> I am using gentoo, but I have never installed myth through gentoo,
>> always compiled from source.  mysql was install through gentoo with
>> the following use flags:
>> [ebuild   R   ] dev-db/mysql-5.0.70-r1  USE="berkdb perl ssl
>> -big-tables -cluster -debug -embedded -extraengine -latin1
>> -max-idx-128 -minimal (-selinux) -static"
> And that probably explains why it's broken--your MySQL server is 
> misconfigured.
>
> Any system that handles MythTV data that was created with a version of 
> MythTV that uses database schema version 1215 or before /must/ have 
> support for latin1 in the MySQL server.
>
> (Based on my /extremely/ limited knowledge of Gentoo/emerge/use flags, 
> it seems that) Since you emerged MySQL with the "-latin1" use flag, you 
> disabled latin1 support.  You can verify that you're lacking latin1 
> support with:
>
> SHOW CHARSET LIKE 'latin1%';

OK, I don't know what -latin1 use flag means, but it seems that a mysql 
server compiled with it still has support for latin1 charset.

So, I'm back to having no idea why the conversion failed for on your system.

Mike