On 10/9/07, <b class="gmail_sendername">Michael T. Dean</b> <<a href="mailto:mtdean@thirdcontact.com">mtdean@thirdcontact.com</a>> wrote:<div><span class="gmail_quote"></span><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
On 10/09/2007 03:50 PM, Joacim J wrote:<br>> I have problems with swedish characters in the database and showing it<br>> in myth.<br>><br>> The mysql collation is "latin1_swedish_ci" and the database server has
<br>> "UTF-8 Unicode (utf8)"<br>><br>> Should I have collation "utf8_swedish_ci" instead??<br><br>No. And, if you change it now, though things will appear to work, when<br>you upgrade in the future, not only will Myth break, but all your data
<br>will break. Changing the encoding is a database time bomb. Every<br>post/HOWTO where people suggest this is just setting someone up for a<br>big problem in the future.<br><br>Why:<br><a href="http://www.gossamer-threads.com/lists/mythtv/commits/264510#264510">
http://www.gossamer-threads.com/lists/mythtv/commits/264510#264510</a><br><a href="http://www.gossamer-threads.com/lists/mythtv/dev/227559#227559">http://www.gossamer-threads.com/lists/mythtv/dev/227559#227559</a><br><br>
So, what you need to do is find the locations where we're missing the<br>UTF encode/decode in the MythTV source code and submit a patch.<br><br>Mike</blockquote><div><br></div></div>Hello,<br><br>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??
<br><br>Is this a correct understanding??<br>-- <br>Regards<br>Joacim