Re: PostgreSQL 9.0.3 - collate/ctype order by hu_HU.UTF8 is not correct sorting

From: Radosław Smogura <rsmogura(at)softperience(dot)eu>
To: Adam PAPAI <adam(dot)papai(at)bsdsupportservice(dot)hu>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: PostgreSQL 9.0.3 - collate/ctype order by hu_HU.UTF8 is not correct sorting
Date: 2011-02-06 14:39:08
Message-ID: 201102061539.08521.rsmogura@softperience.eu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Adam PAPAI <adam(dot)papai(at)bsdsupportservice(dot)hu> Sunday 06 February 2011 14:13:51
> Radosław Smogura wrote:
> > You need to create database with LC_COLLATE="hu_HU.utf8", e.g.
> >
> > CREATE DATABASE tx2 ENCODING='UTF-8' TEMPLATE=template0
> > LC_COLLATE='pl_PL.utf8';
>
> Are you running it under FreeBSD?

No, Gentoo. But, without creating db with LC_COLLATE I get wrong sroting too.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Herouth Maoz 2011-02-06 15:07:14 What's canceling autovacuum tasks?
Previous Message Yves Weißig 2011-02-06 14:14:37 Re: effective_io_concurrency