Re: unicode searches failing that use % and LIKE operators

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