utf8 : utf8_general_ci O=o=Ò=Ó=Ô=Õ=Ö=ò=ó=ô=õ=ö oe oz utf8 : utf8_general_mysql500_ci O=o=Ò=Ó=Ô=Õ=Ö=ò=ó=ô=õ=ö oe oz utf8 : utf8_danish_ci O=o=º=Ò=Ó=Ô=Õ=ò=ó=ô=õ oe=Œ=œ oz utf8 : utf8_swedish_ci O=o=º=Ò=Ó=Ô=Õ=ò=ó=ô=õ oe=Œ=œ oz utf8 : utf8_estonian_ci O=o=º=Ò=Ó=Ô=ò=ó=ô oe=Œ=œ oz Ø=ø utf8 : utf8_unicode_ci O=o=º=Ò=Ó=Ô=Õ=Ö=ò=ó=ô=õ=ö oe=Œ=œ oz Ø=ø utf8 : utf8_polish_ci O=o=º=Ò=Ô=Õ=Ö=ò=ô=õ=ö oe=Œ=œ oz Ó=ó Ø=ø utf8 : utf8_spanish_ci O=o=º=Ò=Ó=Ô=Õ=Ö=ò=ó=ô=õ=ö oe=Œ=œ oz Ø=ø utf8 : utf8_spanish2_ci O=o=º=Ò=Ó=Ô=Õ=Ö=ò=ó=ô=õ=ö oe=Œ=œ oz Ø=ø
As I understand it, the oe ligature collates as it it were the two letters "oe" for most utf8 collations. However for utf8_general*, it collates after Z: utf8_general_ci X=x Y=y=Ý=ý=ÿ=Ÿ yz Z=z=Ž=ž zh zz Æ=æ Ð=ð Ø=ø Þ=þ Ł=ł Œ=œ ƒ LJ=Lj=lj utf8_general_mysql500_ci X=x Y=y=Ý=ý=ÿ=Ÿ yz Z=z=Ž=ž zh zz Æ=æ Ð=ð Ø=ø Þ=þ ß Ł=ł Œ=œ ƒ LJ=Lj=lj Is this what you mean by "barfs"? > -----Original Message----- > 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" <rja...@yahoo-inc.com> > > > > 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, but > while utf8_unicode_ci does properly handle that, it stil barfs on cœr > (that's oe in one character) and I'm wondering why. > > > 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 another, > > compatible, collation". > > > > They were caught between a rock and a hard place. > > The hard place being having to go "oops, sorry we broke things, we > reverted the change and will introduce a new default collation in the > next version"? Yes, poor software vendors, why do people always expect > them to admit they made a mistake in judgement. > > And, of course, "alter table foo collate utf8_general_mysql500_ci" > doesn't do what you hope, either. It changes the table's default > collation nicely, and then explicitly adds the *old* collation to all > the rows you were hoping to have fixed. > > 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. > > -- > Linux Bier Wanderung 2012, now also available in Belgium! > August, 12 to 19, Diksmuide, Belgium - http://lbw2012.tuxera.be