[mythtv-users] Swedish characters in database
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.
> 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.
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...
More information about the mythtv-users