Re: BUG #9722: select ILIKE is not case insensitive in UTF8 cyrillic - Mailing list pgsql-bugs

From Martin Vassilev
Subject Re: BUG #9722: select ILIKE is not case insensitive in UTF8 cyrillic
Date
Msg-id 2539030.MTBRJ6mVrk@mv-office
Whole thread Raw
In response to Re: BUG #9722: select ILIKE is not case insensitive in UTF8 cyrillic  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
On Wednesday, March 26, 2014 09:58:35 Tom Lane wrote:
> Martin Vassilev <mv@netsurf.bg> writes:
> > Hi Tom,
> >
> >> Perhaps you don't have the database locale/encoding set correctly?
> >> (Look at the lc_collate and lc_ctype settings, and compare to what
> >> you were using in 8.4.)
> >
> > the 8.4 setup is gone :(
>
> That's not a reason not to identify what you've got now.
>
> > Here is my locale settings:
> >
> > ~# locale
> > LANG=en_US.UTF-8
> > LC_CTYPE="en_US.UTF-8"
> > LC_COLLATE=C
>
> This is your shell environment, which may or may not have much to do with
> what Postgres is using: you need to look at the lc_collate and lc_ctype
> parameters for each database.  However, it would not surprise me at all
> if an en_US setting doesn't case-fold Cyrillic characters --- and a C
> setting most certainly wouldn't.
>
I just recreated DB with --lc-collate=bg_BG.utf8 --lc-ctype=bg_BG.utf8
and it is fine now.
Thanks for support.

--

Best regards ,
Martin Vassilev
Network/System Administrator

Net-Surf.net Ltd.
phone: + 359 96 399994
e-mail: mv@netsurf.bg
http://www.netsurf.bg

pgsql-bugs by date:

Previous
From: Thom Brown
Date:
Subject: Re: [HACKERS] Duplicated row after promote in synchronous streaming replication
Next
From: Martin Vassilev
Date:
Subject: Re: BUG #9722: select ILIKE is not case insensitive in UTF8 cyrillic