Tom,
To be more precise, the mixed queries "fail" in that they return hits of 0
rows, when they should return more than 0 rows.
Ben
In message <19842.1193077201@sss.pgh.pa.us> Tom Lane <tgl@sss.pgh.pa.us>
writes:
> Benjamin Weaver <benjamin.weaver@classics.ox.ac.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
--
Benjamin Weaver
Faculty Research Associate, Imaging Papyri Projects, Herculaneum Society,
Oxford
email: benjamin.weaver@classics.ox.ac.uk
phone: (0)1865 610236