Re: MySQL, UTF8 and collations

2012-08-28 Thread Shawn Green
On 8/28/2012 4:49 AM, Johan De Meersman wrote: ... Guess I'll be fixing it manually (well, sed is my friend) in a mysqldump before syncing up the second node after it's been upgraded. There is another method you can use that doesn't require dump+sed+restore. Convert the column from it's cur

RE: MySQL, UTF8 and collations

2012-08-28 Thread Rick James
e- > From: Johan De Meersman [mailto:vegiv...@tuxera.be] > Sent: Tuesday, August 28, 2012 1:49 AM > To: Rick James > Cc: mysql > Subject: Re: MySQL, UTF8 and collations > > - Original Message - > > From: "Rick James" > > > > There is a

Re: MySQL, UTF8 and collations

2012-08-28 Thread Johan De Meersman
- Original Message - > From: "Rick James" > > There is a section on German Sharp-s in > http://mysql.rjweb.org/doc.php/charcoll > I agree with "dirty". Yes, seen it, but thank you. I'm not having character set issues, everything is nicely UTF8. I'm merely running into the scheiße bug,

RE: MySQL, UTF8 and collations

2012-08-27 Thread Rick James
There is a section on German Sharp-s in http://mysql.rjweb.org/doc.php/charcoll I agree with "dirty". As I understand it, about 5.1.24, they said "Oops, sharp-s is collated wrong, let's fix it". The fix broke things, but they stuck by the "correct" sorting. Eventually they said "Oh, let's add a