Benjamin Weaver <benjamin(dot)weaver(at)classics(dot)ox(dot)ac(dot)uk> 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