[mythtv-users] Heads up - Gentoo 0.22 Upgrade Coming Soon
Michael T. Dean
mtdean at thirdcontact.com
Tue Mar 2 05:06:45 UTC 2010
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.)
More information about the mythtv-users