Postgres Pro
Downloads
Home   >   mailing lists

Re: SELECT - ORDER BY Croatian characters .... - Mailing list pgsql-sql

From Peter Eisentraut
Subject Re: SELECT - ORDER BY Croatian characters ....
Date
Msg-id 200405072039.09952.peter_e@gmx.net
Whole thread Raw
In response to SELECT - ORDER BY Croatian characters ....  ("Kornelije" <krabuzin@foi.hr>)
Responses Re: SELECT - ORDER BY Croatian characters ....
List pgsql-sql
Tree view 
Kornelije wrote:
> I'm using PostgreSQL and my database contains Croatian Characters
> (ccz...).... so when I pose a query, and I use order by clause, the
> result is not sorted properly.....

You need to initdb your database with the proper locale (hr_HR, 
probably).  Also, choose the right encoding to go along with the locale 
(LATIN2?).

pgsql-sql by date:

Previous
From: Jean-Luc Lachance
Date:
Subject: Re: SUM() & GROUP BY
Next
From: "Jie Liang"
Date:
Subject: \df