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@xxxxxxxxxxxxxxxxxx> Gregory Stark <stark@xxxxxxxxxxxxxxxx> writes: > "Benjamin Weaver" <benjamin.weaver@xxxxxxxxxxxxxxxxx> 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@xxxxxxxxxxxxxxxxx phone: (0)1865 610236 ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
