[mythtv-users] Error when changing Mythtv's mysql database from utf8 to latin1 on Gentoo

[David Liana]

On Wed, Nov 11, 2009 at 3:16 PM, Michael T. Dean <mtdean at thirdcontact.com>wrote:

> On 11/11/2009 11:38 AM, Steve Evans wrote:
>
>> I am using Mythtv 0.21 on Gentoo. Gentoo sets up mysql to use utf8,
>> but Mythtv prefers it to use latin1. This will cause problems when
>> Mythtv is upgraded to 0.22. There are instructions on how to fix this at:
>>
>> http://wiki.mythtv.org/wiki/Fixing_Corrupt_Database_Encoding
>>
>> I followed these instructions, but got this error when restoring the fixed
>> backup:
>>
>> ERROR 1062 (23000) at line 1712: Duplicate entry 'Kathleen ÃôDixieÃö
>> Dixon*Jane Hazlegr' for key 2
>>
>>
>
> That means you have partial corruption.
>
>
> Fortunately it was possible to restore the original, unfixed, backup,
>> so I have a working mythtv :-)
>>
>> Does anyone have any idea how to fix the database /without/ getting this
>> error?
>>
>
> You need to follow the instructions at:
>
> http://www.gossamer-threads.com/lists/mythtv/users/406111#406111
>
> Mike
>
> _______________________________________________
> mythtv-users mailing list
> mythtv-users at mythtv.org
> http://mythtv.org/cgi-bin/mailman/listinfo/mythtv-users
>

I followed the directions on the posted thread on my end... Started with a
clean v0.21-fixes DB in latin1 charset, upgraded to v0.22, ran the setup...
Will the resulting v0.22 database be utf8?
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mythtv.org/pipermail/mythtv-users/attachments/20091111/4feb9715/attachment.htm>