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 ....
Date: Sat, 8 May 2004 11:54:53 +0200 (MEST)
Message-ID: <Pine.GSO.4.58.0405081052330.5471@barok.foi.hr> (raw)
In-Reply-To: <200405072039.09952.peter_e@gmx.net>
References: <006101c43429$a7b24c40$b103a8c0@krabuzin>
<200405072039.09952.peter_e@gmx.net>
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?).
>
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: krabuzin@foi.hr, peter_e@gmx.net
Subject: Re: SELECT - ORDER BY Croatian characters ....
In-Reply-To: <Pine.GSO.4.58.0405081052330.5471@barok.foi.hr>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox