Re: [SQL] SELECT - ORDER BY Croatian characters ....

2004-05-10 Thread Kornelije Rabuzin
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

[SQL] SELECT - ORDER BY Croatian characters ....

2004-05-07 Thread Kornelije
Hi everybody, I'm using PostgreSQL and my database contains Croatian Characters (ž...) so when I pose a query, and I use order by clause, the result is not sorted properly. I was usingonce VB for aplications and thereI've used a function which changed Croatian characters with some

Re: [SQL] SELECT - ORDER BY Croatian characters ....

2004-05-07 Thread Peter Eisentraut
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