Re: unicode searches failing that use % and LIKE operators

From: Gregory Stark <stark(at)enterprisedb(dot)com>
To: "Benjamin Weaver" <benjamin(dot)weaver(at)classics(dot)ox(dot)ac(dot)uk>
Cc: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, <pgsql-general(at)postgresql(dot)org>
Subject: Re: unicode searches failing that use % and LIKE operators
Date: 2007-10-22 21:25:50
Message-ID: 87bqaqhme9.fsf@oxford.xeocode.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Benjamin Weaver" <benjamin(dot)weaver(at)classics(dot)ox(dot)ac(dot)uk> writes:

> Tom,
>
> Thanks. I am running:
>
> Postgres 8.1.4
> server_encoding UTF8
> lc_collate en_GB.UTF-8
> lc_ctype en_GB.UTF-8

Hm, I wonder what the en_GB locale on your machine does when it sees
characters unused in English such as Greek characters. Is this Windows or some
form of Unix?

Do you have a particular LIKE pattern and a particular example for which it
fails? Or does it work reasonably when you test individual values but fail
when you perform large searches?

--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2007-10-22 21:39:56 Re: [HACKERS] 8.2.3: Server crashes on Windows using Eclipse/Junit
Previous Message Martin Marques 2007-10-22 21:01:58 Re: Bitmap Heap scan 8.1/8.2