Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: LC_COLLATE could cause a LOWER/UPPER/ILIKE malfunction?
Date
Msg-id 4113.1264183420@sss.pgh.pa.us
Whole thread Raw
In response to LC_COLLATE could cause a LOWER/UPPER/ILIKE malfunction?  (Daniel Cristian Cruz <danielcristian@gmail.com>)
List pgsql-admin
Tree view 
Daniel Cristian Cruz <danielcristian@gmail.com> writes:
> I found this problem, where 'ã' MUST be ILIKE 'Ã' (PostgreSQL 8.2.12, RedHat
> x86_64):

Is your database encoding iso88591?  IIRC, 8.2 will try to warn you if
the encoding doesn't match the locale setting, but it doesn't completely
refuse nonsensical combinations.  However, a nonsensical combination
could easily cause bad results from upper().

            regards, tom lane

pgsql-admin by date:

Previous
From: Daniel Cristian Cruz
Date:
Subject: LC_COLLATE could cause a LOWER/UPPER/ILIKE malfunction?
Next
From: Michael Monnerie
Date:
Subject: max_fsm_pages question