Postgres Pro
Downloads
Home   >   mailing lists

Re: unicode searches failing that use % and LIKE operators - Mailing list pgsql-general

From fabio fumarola
Subject Re: unicode searches failing that use % and LIKE operators
Date
Msg-id CAEpYKZaw-OfGNM+X5SfFF7=ggxMX_4egKjkGYJPmQeovrGvYsQ@mail.gmail.com
Whole thread Raw
In response to unicode searches failing that use % and LIKE operators  (Benjamin Weaver <benjamin.weaver@classics.ox.ac.uk>)
List pgsql-general
Tree view
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

pgsql-general by date:

Previous
From: Edson Richter
Date:
Subject: Re: log_destination = csvlog, line breaks interfere in analysis
Next
From: John R Pierce
Date:
Subject: Re: Official C++ API for postgresql?