[mythtv-users] Swedish characters in database

[Joacim J]

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


Hello,

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??
-- 
Regards
Joacim
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mythtv.org/pipermail/mythtv-users/attachments/20071009/8331fa3f/attachment.htm