Re: LC_COLLATE could cause a LOWER/UPPER/ILIKE malfunction?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Daniel Cristian Cruz <danielcristian(at)gmail(dot)com>
Cc: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: Re: LC_COLLATE could cause a LOWER/UPPER/ILIKE malfunction?
Date: 2010-01-22 18:03:40
Message-ID: 4113.1264183420@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Daniel Cristian Cruz <danielcristian(at)gmail(dot)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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Michael Monnerie 2010-01-25 11:19:12 max_fsm_pages question
Previous Message Daniel Cristian Cruz 2010-01-22 17:36:25 LC_COLLATE could cause a LOWER/UPPER/ILIKE malfunction?