Search Postgresql Archives

Re: unicode searches failing that use % and LIKE operators

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Tom,

Thanks.  I am running: 

Postgres 8.1.4
server_encoding  UTF8
lc_collate en_GB.UTF-8
lc_ctype   en_GB.UTF-8

Ben 

In message <19842.1193077201@xxxxxxxxxxxxx> Tom Lane <tgl@xxxxxxxxxxxxx> 
writes:
> 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

-- 
Benjamin Weaver
Faculty Research Associate, Imaging Papyri Projects, Herculaneum Society, 
Oxford
email:  benjamin.weaver@xxxxxxxxxxxxxxxxx
phone:  (0)1865 610236


---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

               http://archives.postgresql.org/

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux