List:General Discussion« Previous MessageNext Message »
From:Rick James Date:June 13 2012 11:31pm
Subject:RE: Minor collation question
View as plain text  
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: mysql@strippedsql.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
> from
> > 5.0 to 5.5 where that problem is resolved.  Sure, it's a bit more
> work
> > (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
> information.
> 
> > Yes, collations are used for equality and inequality comparisons,
> too,
> > 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

Thread
Minor collation questionJohan De Meersman12 Jun
  • Re: Minor collation questionShawn Green12 Jun
    • Re: Minor collation questionJohan De Meersman13 Jun
      • RE: Minor collation questionRick James13 Jun
        • Re: Minor collation questionJohan De Meersman14 Jun
          • Re: Minor collation questionwalter14 Jun