LC_COLLATE could cause a LOWER/UPPER/ILIKE malfunction?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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
クルズ  クリスチアン ダニエル

[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux