[mythtv-users] Current Trunk, mysql latin1 and gentoo oddities

[Michael T. Dean]

On 03/12/2009 04:20 PM, Tom Dexter wrote:
> On Thu, Mar 12, 2009 at 3:37 PM, Michael T. Dean wrote:
>   
>> On 03/12/2009 03:31 PM, Tom Dexter wrote:
>>     
>>> On Thu, Mar 12, 2009 at 3:00 PM, Michael T. Dean wrote:
>>>       
>>>> OK.  Just to clarify.  The MySQL Server configuration requirement (that
>>>> most
>>>> Gentoo users' MySQL servers don't meet--i.e. configuring the server to
>>>> use
>>>> the latin1 character set) is a requirement for -fixes databases, only.
>>> Hi Mike...I remember when this came up earlier.  For those of us
>>> running 0.21-fixes with the default Gentoo UTF8 setup (where the
>>> server defaults are UTF8 but the database was in fact created with
>>> wc.sql with the latin1 defaults for mythconverg), does the statement
>>> you made here still apply?:
>>>
>>> http://www.gossamer-threads.com/lists/mythtv/users/362243#362243
>> Best information is at
>> http://www.mythtv.org/wiki/Fixing_Corrupt_Database_Encoding .
> Ah...thanks.  It sounds like I'm best off leaving things alone until I
> upgrade, which I'm not going to do until 0.22 is ready.

That's my recommendation.  If you haven't noticed any problems, don't 
worry about it, yet.

If, however, you're just starting and planning to use a non-Latin 
character set in Myth, you will /have/ to configure your server properly 
or it will not work.  (If you're not just starting and your server is 
misconfigured, you're not using a non-Latin character set, as you would 
have noticed a lot of problems.)

Mike