Re: String comparison problem in select - too many results

["David G. Johnston" <david.g.johnston@xxxxxxxxx>]

On Wednesday, January 10, 2018, Durumdara <durumdara@xxxxxxxxx> 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.