LC_COLLATE could cause a LOWER/UPPER/ILIKE malfunction?

From: Daniel Cristian Cruz <danielcristian(at)gmail(dot)com>
To: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: LC_COLLATE could cause a LOWER/UPPER/ILIKE malfunction?
Date: 2010-01-22 17:36:25
Message-ID: 48d0cacb1001220936y7562c844g224421ba4e4d2d2a@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

I found this problem, where 'ã' MUST be ILIKE 'Ã' (PostgreSQL 8.2.12, RedHat
x86_64):

brd2=# SET client_encoding TO unicode;
SET
brd2=# SELECT 'ã' LIKE 'ã';
?column?
----------
t
(1 registro)

brd2=# SELECT UPPER('ã') LIKE UPPER('ã');
?column?
----------
t
(1 registro)

brd2=# SELECT 'Ã' LIKE UPPER('ã');
?column?
----------
f
(1 registro)

brd2=# SHOW lc_collate ;
lc_collate
----------------
pt_BR.iso88591
(1 registro)

The correct LC_COLLATE would be pt_BR.utf8 or is it a bug?

--
Daniel Cristian Cruz
クルズ クリスチアン ダニエル

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2010-01-22 18:03:40 Re: LC_COLLATE could cause a LOWER/UPPER/ILIKE malfunction?
Previous Message Allen Johnson 2010-01-22 14:51:20 Re: Permission to postgres to another user's folder