Postgres Pro
Downloads
Home   >   mailing lists

Re: String comparison problem in select - too many results - Mailing list pgsql-general

From David G. Johnston
Subject Re: String comparison problem in select - too many results
Date
Msg-id CAKFQuwbdQpiAJjx89r8Lsk0t=A5T-KmYnPSVDY+wm=XgxH=pMw@mail.gmail.com
Whole thread Raw
In response to String comparison problem in select - too many results  (Durumdara <durumdara@gmail.com>)
Responses Re: String comparison problem in select - too many results  (Durumdara <durumdara@gmail.com>)
List pgsql-general
Tree view
On Wednesday, January 10, 2018, Durumdara <durumdara@gmail.com> wrote:

The PG is 9.4 on Linux, the DataBase encoding is:
       ENCODING = 'UTF8'
       LC_COLLATE = 'hu_HU.UTF-8'
       LC_CTYPE = 'hu_HU.UTF-8'


The collection rules for hu_HU.UTF-8 probably pretend symbols don't exist, this is not uncommon.  You probably need to use 'C' collation.

David J. 

pgsql-general by date:

Previous
From: Márcio A. Sepp
Date:
Subject: RES: help with generation_series in pg10
Next
From: pinker
Date:
Subject: Re: How Many Partitions are Good Performing