On 6/28/07, Trevor Talbot <[EMAIL PROTECTED]> wrote:
On 6/28/07, Nuno Lucas <[EMAIL PROTECTED]> wrote:
> One thing I noticed is that "collations" != "case change". This will
> not make it possible to use UPPER/LOWER with the same data on the
> table, but maybe we can work on something in that respect, also.
If the intent is case-insensitive comparisons a la LIKE, note that
"upper" and "lower" operations alone won't suffice, because in some
scripts a single character maps to multiple characters in one
direction. Unicode defines a "case folding" operation for such uses,
which does full expansion no matter which direction it is
(lower->upper or upper->lower), allowing the result to be handled with
a simple memcmp()-style binary comparison.
Right, an example is the german "straße" -> "STRASSE" (the 'ß' - beta
- character being replaced by "SS" in uppercase, for those who can't
see the mail properly).
It should certainly be possible to cover those operations too, it's
just as nuanced as the collation work :)
Yes. I'll try to think on this too, but not the big priority.
Best regards,
~Nuno Lucas
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
