"Benjamin Weaver" <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org/
