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

Поиск
Список
Период
Сортировка
От Kornelije Rabuzin
Тема Re: SELECT - ORDER BY Croatian characters ....
Дата
Msg-id Pine.GSO.4.58.0405081052330.5471@barok.foi.hr
обсуждение исходный текст
Ответ на Re: SELECT - ORDER BY Croatian characters ....  (Peter Eisentraut <peter_e@gmx.net>)
Список 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 по дате отправления:

Предыдущее
От: "Bernard Cheung"
Дата:
Сообщение: Trigger function to know which fields are being updated
Следующее
От: Jeff Kowalczyk
Дата:
Сообщение: update table where rows are selected by inner join?