Re: unicode searches failing that use % and LIKE operators - Mailing list pgsql-general

"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