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.fsf@oxford.xeocode.com> Gregory Stark
<stark@enterprisedb.com> writes:
> "Benjamin Weaver" <benjamin.weaver@classics.ox.ac.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.weaver@classics.ox.ac.uk
phone: (0)1865 610236