pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedSELECT - ORDER BY Croatian characters ....
3+ messages / 3 participants
[nested] [flat]
* SELECT - ORDER BY Croatian characters ....
@ 2004-05-07 11:51 Kornelije <krabuzin@foi.hr>
2004-05-07 18:39 ` Re: SELECT - ORDER BY Croatian characters .... Peter Eisentraut <peter_e@gmx.net>
0 siblings, 1 reply; 3+ messages in thread
From: Kornelije @ 2004-05-07 11:51 UTC (permalink / raw)
To: pgsql-sql
Hi everybody,
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.....
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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: SELECT - ORDER BY Croatian characters ....
2004-05-07 11:51 SELECT - ORDER BY Croatian characters .... Kornelije <krabuzin@foi.hr>
@ 2004-05-07 18:39 ` Peter Eisentraut <peter_e@gmx.net>
2004-05-08 09:54 ` Re: SELECT - ORDER BY Croatian characters .... Kornelije Rabuzin <krabuzin@foi.hr>
0 siblings, 1 reply; 3+ messages in thread
From: Peter Eisentraut @ 2004-05-07 18:39 UTC (permalink / raw)
To: Kornelije <krabuzin@foi.hr>; pgsql-sql
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?).
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: SELECT - ORDER BY Croatian characters ....
2004-05-07 11:51 SELECT - ORDER BY Croatian characters .... Kornelije <krabuzin@foi.hr>
2004-05-07 18:39 ` Re: SELECT - ORDER BY Croatian characters .... Peter Eisentraut <peter_e@gmx.net>
@ 2004-05-08 09:54 ` Kornelije Rabuzin <krabuzin@foi.hr>
0 siblings, 0 replies; 3+ messages in thread
From: Kornelije Rabuzin @ 2004-05-08 09:54 UTC (permalink / raw)
To: Peter Eisentraut <peter_e@gmx.net>; +Cc: 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?).
>
>
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2004-05-08 09:54 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-05-07 11:51 SELECT - ORDER BY Croatian characters .... Kornelije <krabuzin@foi.hr>
2004-05-07 18:39 ` Peter Eisentraut <peter_e@gmx.net>
2004-05-08 09:54 ` Kornelije Rabuzin <krabuzin@foi.hr>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox