Postgres Pro
Downloads
Home   >   mailing lists

LC_COLLATE could cause a LOWER/UPPER/ILIKE malfunction? - Mailing list pgsql-admin

From Daniel Cristian Cruz
Subject LC_COLLATE could cause a LOWER/UPPER/ILIKE malfunction?
Date
Msg-id 48d0cacb1001220936y7562c844g224421ba4e4d2d2a@mail.gmail.com
Whole thread Raw
Responses Re: LC_COLLATE could cause a LOWER/UPPER/ILIKE malfunction?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
Tree view
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
クルズ  クリスチアン ダニエル

pgsql-admin by date:

Previous
From: Allen Johnson
Date:
Subject: Re: Permission to postgres to another user's folder
Next
From: Tom Lane
Date:
Subject: Re: LC_COLLATE could cause a LOWER/UPPER/ILIKE malfunction?