[mythtv-users] Swedish characters in database

[Michael T. Dean]

On 10/09/2007 03:50 PM, Joacim J wrote:
> I have problems with swedish characters in the database and showing it
> in myth.
>
> The mysql collation is "latin1_swedish_ci" and the database server has
> "UTF-8 Unicode (utf8)"
>
> Should I have collation "utf8_swedish_ci" instead??

No.  And, if you change it now, though things will appear to work, when
you upgrade in the future, not only will Myth break, but all your data
will break.  Changing the encoding is a database time bomb.  Every
post/HOWTO where people suggest this is just setting someone up for a
big problem in the future.

Why:
http://www.gossamer-threads.com/lists/mythtv/commits/264510#264510
http://www.gossamer-threads.com/lists/mythtv/dev/227559#227559

So, what you need to do is find the locations where we're missing the
UTF encode/decode in the MythTV source code and submit a patch.

Mike