Re: String comparison problem in select - too many results

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Durumdara <durumdara(at)gmail(dot)com>
Cc: Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Re: String comparison problem in select - too many results
Date: 2018-01-10 15:25:10
Message-ID: CAKFQuwbdQpiAJjx89r8Lsk0t=A5T-KmYnPSVDY+wm=XgxH=pMw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wednesday, January 10, 2018, Durumdara <durumdara(at)gmail(dot)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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message pinker 2018-01-10 17:06:31 Re: How Many Partitions are Good Performing
Previous Message Márcio A. Sepp 2018-01-10 15:22:07 RES: help with generation_series in pg10