Re: unicode searches failing that use % and LIKE operators

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