X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.2])
	by svr1.postgresql.org (Postfix) with ESMTP id 3597FD1DB5C
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Sat,  8 May 2004 06:55:17 -0300 (ADT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024)
	with ESMTP id 33947-02
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Sat,  8 May 2004 06:54:58 -0300 (ADT)
Received: from barok.foi.hr (barok.foi.hr [161.53.120.3])
	by svr1.postgresql.org (Postfix) with ESMTP id 54BE2D1F6BD
	for <pgsql-sql@postgresql.org>; Sat,  8 May 2004 06:54:55 -0300 (ADT)
Received: from barok.foi.hr (krabuzin@localhost [127.0.0.1])
	by barok.foi.hr (8.12.10/8.12.10) with ESMTP id i489suWQ007523;
	Sat, 8 May 2004 11:54:56 +0200 (MEST)
Received: from localhost (krabuzin@localhost)
	by barok.foi.hr (8.12.10/8.12.2/Submit) with ESMTP id i489srte007520;
	Sat, 8 May 2004 11:54:53 +0200 (MEST)
Date: Sat, 8 May 2004 11:54:53 +0200 (MEST)
From: Kornelije Rabuzin <krabuzin@foi.hr>
To: Peter Eisentraut <peter_e@gmx.net>
Cc: pgsql-sql@postgresql.org
Subject: Re: SELECT - ORDER BY Croatian characters ....
In-Reply-To: <200405072039.09952.peter_e@gmx.net>
Message-ID: <Pine.GSO.4.58.0405081052330.5471@barok.foi.hr>
References: <006101c43429$a7b24c40$b103a8c0@krabuzin>
	<200405072039.09952.peter_e@gmx.net>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII
X-Virus-Scanned: by amavisd-new at postgresql.org
X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests=
X-Spam-Level: 
X-Archive-Number: 200405/88
X-Sequence-Number: 17802


Thanks, but the problem is that I'm not using this database alone and
there exist also some other users; so I've found this locale setings
(lc_collate), but this cannot be changed because some indexes will be
probably damaged.....

so database is not set up properly...... but I've
started to work with this database and it cannot be changed .....so
I've
to found some other solution ...... so if you know if it's feasible to
write some function......

thank you very much ;-)

Kornelije


On Fri, 7 May 2004, Peter Eisentraut wrote:

> 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?).
>
>