Tom, Thanks. I am running: Postgres 8.1.4 server_encoding UTF8 lc_collate en_GB.UTF-8 lc_ctype en_GB.UTF-8 Ben In message <19842.1193077201@xxxxxxxxxxxxx> Tom Lane <tgl@xxxxxxxxxxxxx> writes: > Benjamin Weaver <benjamin.weaver@xxxxxxxxxxxxxxxxx> writes: > > I have the following problem: a compound search, involving 2 wildcarded > > character search terms, in which one search term consists of Latin characters > > and the other, of UTF-8 unicode Greek characters, fails. This is strange, > > because similar searches in which both terms are either unicode Greek or Latin > > characters succeed. > > That's pretty strange all right. What PG version is this, what database > encoding are you using, and what are the server's lc_collate and > lc_ctype settings? > > regards, tom lane -- Benjamin Weaver Faculty Research Associate, Imaging Papyri Projects, Herculaneum Society, Oxford email: benjamin.weaver@xxxxxxxxxxxxxxxxx phone: (0)1865 610236 ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org/