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(dot)1193077201(at)sss(dot)pgh(dot)pa(dot)us> Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
writes:
> 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

--
Benjamin Weaver
Faculty Research Associate, Imaging Papyri Projects, Herculaneum Society,
Oxford
email: benjamin(dot)weaver(at)classics(dot)ox(dot)ac(dot)uk
phone: (0)1865 610236