Re: BUG: ILIKE with single-byte encoding

Rolf Jentsch <RJentsch@electronicpartner.de> writes:
> With PostgreSQL 8.3.0 the following bug has been introduced with the ILIKE or
> ~~* operator:
> In a database with single-byte encoding as LATIN1 the expression
> SELECT 'aü' ILIKE '%ü';
> returns false.

> For the single-byte case there are some places where a (signed) char
> value is compared to the return value auf tolower() which is an int.

Patch applied, thanks!  It turns out there was a second bug on the very
same line: some machines have problems if the argument of tolower()
isn't explicitly cast to unsigned char ...

            regards, tom lane