Re: locale-aware string comparisons

>>>>> "MD" == Mark Davis ☕ <mark_at_macchiato.com> 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 <cloos_at_jhcloos.com>         OpenPGP: 1024D/ED7DAEA6