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

From Kornelije Rabuzin
Subject Re: SELECT - ORDER BY Croatian characters ....
Date
Msg-id Pine.GSO.4.58.0405081052330.5471@barok.foi.hr
Whole thread Raw
In response to Re: SELECT - ORDER BY Croatian characters ....  (Peter Eisentraut <peter_e@gmx.net>)
List 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?).
>
>


pgsql-sql by date:

Previous
From: "Bernard Cheung"
Date:
Subject: Trigger function to know which fields are being updated
Next
From: Jeff Kowalczyk
Date:
Subject: update table where rows are selected by inner join?