I'd try to avoid making a dependency where case mapping needs to be the same as case insensitive comparisons.
I'd either always case fold then compare, or always compare case insensitive. -Shawn -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of James Cloos Sent: Tuesday, January 1, 2013 5:43 PM To: Mark Davis ☕ Cc: Whistler, Ken; [email protected] Subject: Re: locale-aware string comparisons >>>>> "MD" == Mark Davis ☕ <[email protected]> writes: MD> All of these are different, all of them still have over 200 MD> differences from either compare(lower(x),lower(y)) or compare(upper MD> (x),upper(y)) What about, then: compare(lower(x),lower(y)) || compare(upper(x),upper(y)) Or, to emphasize that I mentioned C only as a pseudocode, akin to SQL: LOWER(x) LIKE LOWER(y) OR UPPER(x) LIKE UPPER(y) Would that cover all of the outliers? -JimC -- James Cloos <[email protected]> OpenPGP: 1024D/ED7DAEA6
