Skip site navigation (1) Skip section navigation (2)

Re: SELECT - ORDER BY Croatian characters ....

From: Kornelije Rabuzin <krabuzin(at)foi(dot)hr>
To: Peter Eisentraut <peter_e(at)gmx(dot)net>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: SELECT - ORDER BY Croatian characters ....
Date: 2004-05-08 09:54:53
Message-ID: Pine.GSO.4.58.0405081052330.5471@barok.foi.hr (view raw or flat)
Thread:
Lists: pgsql-sql
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?).
>
>

In response to

pgsql-sql by date

Next:From: Bruno Wolff IIIDate: 2004-05-08 16:36:41
Subject: Re: techniques for manual ordering of data ?
Previous:From: Gaetano MendolaDate: 2004-05-07 23:50:22
Subject: Re: CONTEXT on PL/pgSQL

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group