From: | Benjamin Weaver <benjamin(dot)weaver(at)classics(dot)ox(dot)ac(dot)uk> |
---|---|
To: | Gregory Stark <stark(at)enterprisedb(dot)com> |
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:49:32 |
Message-ID: | 20071022214932.E210B94047@webmail220.herald.ox.ac.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Dear Greg, Tom,
I AM in fact running the db on Linux. Redhat 9. Are the encoding parameters
wrong for Linux?
I am sending the queries via JDBC from a windows machine. But I have also
gotten the same results via psql when sending the queries from one local redhat
9 box to the redhat 9 database server box.
Ben
In message <87bqaqhme9(dot)fsf(at)oxford(dot)xeocode(dot)com> Gregory Stark
<stark(at)enterprisedb(dot)com> writes:
> "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
--
Benjamin Weaver
Faculty Research Associate, Imaging Papyri Projects, Herculaneum Society, Oxford
email: benjamin(dot)weaver(at)classics(dot)ox(dot)ac(dot)uk
phone: (0)1865 610236
From | Date | Subject | |
---|---|---|---|
Next Message | Pavel Stehule | 2007-10-22 21:59:56 | Re: Bitmap Heap scan 8.1/8.2 |
Previous Message | Tom Lane | 2007-10-22 21:39:56 | Re: [HACKERS] 8.2.3: Server crashes on Windows using Eclipse/Junit |