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