----- 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

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.