A warning about β -- There was a change in the collation at 5.1.24.
Search http://mysql.rjweb.org/doc.php/charcoll for 'German'; there is a brief discussion near the end.
> -----Original Message-----
> From: Johan De Meersman [mailto:vegivamp@stripped]
> Sent: Wednesday, June 13, 2012 2:26 AM
> To: Shawn Green
> Cc: email@example.com
> Subject: Re: Minor collation question
> ----- Original Message -----
> > From: "Shawn Green" <shawn.l.green@stripped>
> > The other tactical move has been to jump 5.1 and upgrade directly
> > 5.0 to 5.5 where that problem is resolved. Sure, it's a bit more
> > (full dump/restore is highly recommended) but it avoids the collation
> > bug which exists in all 5.1.x releases.
> Ah! Everything I found in the bug tracker pointed towards an official
> attitude of "No, that was a bug in 5.0 that got fixed in 5.1. Works as
> designed, will not fix."
> Jumping straight to 5.5 is a viable path, then, so I'll see with the
> Unix boys wether they're willing to go that route. Thank you for that
> > Yes, collations are used for equality and inequality comparisons,
> > not just sorting. That's why having alternate spellings ,like the
> > words "strasse" and "straβe", will collide within a PK in 5.1 where
> > they will not for 5.0 or 5.5 (with the appropriate collation).
> Yes, although here it's colloquially known as the Scheiβe bug :-p
> Bier met grenadyn
> Is als mosterd by den wyn
> Sy die't drinkt, is eene kwezel
> Hy die't drinkt, is ras een ezel
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql