Re: BUG #3737: lower/upper fails to match extended chars in LATIN1

"Heikki Linnakangas" <heikki(at)enterprisedb(dot)com> writes:

> Jonas Forsman wrote:
>
>> Try:
>> select * from table where lower(address) like '%Ã¥%'
>>
>> This select fails to find addresses including capital Ã… and similars in
>> LATIN1 (like Å, Ä, Ö).

Isn't à an upper-case letter? In which case lower(address) will never match it
since by definition lower(address) will only contain characters which are
lower case. That is if address contains a "Ã" then lower(address) will contain
an "ã" instead which won't match the "Ã" in the pattern.

I think you either need to put a lower() on both sides of the LIKE or use
ILIKE.

--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
Get trained by Bruce Momjian - ask me about EnterpriseDB's PostgreSQL training!