[mythtv-users] Heads up - Gentoo 0.22 Upgrade Coming Soon

[Michael T. Dean]

On 03/01/2010 11:22 PM, Steve Hodge wrote:
> On Tue, Mar 2, 2010 at 2:42 PM, Michael T. Dean wrote:
>    
>> TTBOMK, what changed was the default configuration chosen by packages for a
>> certain distro, which build MySQL by specifying a value for --with-charset
>> and, perhaps, --with-collation that override the MySQL defaults with
>> distro-specified defaults and/or provide a start script that specifies
>> --character-set-server and, perhaps, --collation-server to start the server
>> with a specific character set that overrides the MySQL defaults.
>>      
> So is this issue specific to just that one distro (which must therefore
> presumably be Gentoo)? Or have other distros followed suit for some reason?
>    

Any user could have compiled MySQL to change the default charset or 
modified his/her my.cnf or init script to specify a different default 
charset, so anyone on any distro could have been affected by the issue.

I don't know details of distros, but Mythbuntu and MythDora definitely 
had things configured with latin1 character set for MythTV 0.21-fixes 
and below (and I think still with 0.22-fixes), and most people I've 
talked to who were using "default" configurations of MySQL on other 
distros--including Ubuntu, Fedora Core, Mandriva, SUSE--found they had 
latin1 as the server default character set.

Again, though, no one even knew that MythTV 0.21-fixes and below had a 
requirement that the server be configured with a default character set 
of latin1 until it was far too late for many users.  So, it's not 
Gentoo's fault--or anyone else's for that matter.  And those distros 
that did use latin1 didn't do so because they knew MythTV needed 
it--because no one realized that MythTV 0.21-fixes and below needed it.

(Note, also, that after the upgrade to MythTV 0.22 or higher finishes, 
the MySQL server character set configuration should be 
irrelevent--because Qt4's Qt-MySQL driver forces all database 
communications to be UTF-8 whereas Qt3's inherited the server default 
character set, which is the whole reason we were forced to change MythTV 
0.22's physical storage format.)

Mike