Re: LIKE/ESCAPE implementation

Thomas Lockhart <lockhart@alumni.caltech.edu>

From: Thomas Lockhart <lockhart@alumni.caltech.edu>
To: Tom Lane <tgl@sss.pgh.pa.us>, Tatsuo Ishii <t-ishii@sra.co.jp>
Cc: Thomas Swan <tswan@olemiss.edu>, Hackers List <pgsql-hackers@postgresql.org>
Date: 2000-08-06T05:38:06Z
Lists: pgsql-hackers
> Not sure that it matters for multibyte, but for sure LOCALE ought to
> make a difference.  Consider German esstet (sp?) --- that beta-looking
> symbol that lowercases to "ss".  Do we do this correctly?

afaict we do none of this. Using tolower() on a char* variable can not
possibly do the right thing for multiple-byte character sets. Your
example (single byte to two bytes) can't work either.

Tatsuo and others: what is the state of MB for these cases? Should I
just code the single-byte LOCALE solution for now, or do we have some
other code I should be referring to?

                   - Thomas