Re: unicode searches failing that use % and LIKE operators

From: Benjamin Weaver <benjamin(dot)weaver(at)classics(dot)ox(dot)ac(dot)uk>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: unicode searches failing that use % and LIKE operators
Date: 2007-10-22 20:14:22
Message-ID: 20071022201422.954CAEB04E@webmail221.herald.ox.ac.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Magnus Hagander 2007-10-22 20:16:38 Re: 8.2.3: Server crashes on Windows using Eclipse/Junit
Previous Message Dave Page 2007-10-22 20:00:31 Re: 8.2.3: Server crashes on Windows using Eclipse/Junit