Search Postgresql Archives
Re: unicode searches failing that use % and LIKE operators
[
Date Prev
][
Date Next
][
Thread Prev
][
Thread Next
][
Date Index
][
Thread Index
]
To
:
pgsql-general@xxxxxxxxxxxxxx
Subject
: Re: unicode searches failing that use % and LIKE operators
From
: fabio fumarola <
fabiofumarola@xxxxxxxxx
>
Date
: Mon, 17 Sep 2012 22:11:52 +0200
I had the same problem. I solved it by doing query using the pattern matching operator ~*.
I paste an example query
select id_edb,transcription from epigraph where transcription ~* 'εἰρήνῃ'
and it works
best
Fabio
[
Date Prev
][
Date Next
][
Thread Prev
][
Thread Next
][
Date Index
][
Thread Index
]
Prev by Date:
Re: Official C++ API for postgresql?
Next by Date:
Re: log_destination = csvlog
Previous by thread:
Re: unicode searches failing that use % and LIKE operators
Next by thread:
Problem with BYTEA, CAST, and pg_dump
Index(es):
Date
Thread
[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]