[mythtv-users] Swedish characters in database

Joacim J jocke4news at gmail.com
Tue Oct 9 20:37:36 UTC 2007

On 10/9/07, Michael T. Dean <mtdean at thirdcontact.com> wrote:
> 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


Just so I understand it. Swedish characters are not encoded/decoded
correctly and should be considered as a Myth bug. The data in mysql is
(should be) always UTF-8??

Is this a correct understanding??
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mythtv.org/pipermail/mythtv-users/attachments/20071009/8331fa3f/attachment.htm 

More information about the mythtv-users mailing list