Thread: SELECT - ORDER BY Croatian characters ....
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 using once VB for aplications and there I've used a function which changed Croatian characters with some equivalents and sorting order was ok; since now I'm using PHP, is it feasible to write such a function or is there a better solution?
thanks
Kornelije
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?).
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?). > >