pg.ddx.io pgsql-admin@postgresql.org mailing list archivehelp / color / mirror / Atom feed
localization problem 2+ messages / 2 participants [nested] [flat]
* localization problem @ 2006-08-12 18:55 j n <jneuschld@gmail.com> 0 siblings, 1 reply; 2+ messages in thread From: j n @ 2006-08-12 18:55 UTC (permalink / raw) To: pgsql-admin Hellou, can any1 point me to some tutorial what is needed to run localization support ... my problem is when i use order. Whole order is mismatch ... I have a debian linux with postgres 8.1.3 installed while searching the net i found some steps but probably it's not enougth at first locale -a output : C cs_CZ cs_CZ.iso88592 cs_CZ.utf8 czech en_US en_US.iso88591 POSIX sk_SK sk_SK.iso88592 sk_SK.utf8 slovak than creating data directory initdb --locale=sk_SK.utf8 /usr/local/pgsql/dataSK creating database : createdb doctorko -U doctorko -E UTF8 SHOW LC_COLLATE give output sk_SK so everythink look ok but order still not working ... can any 1 help. thanks ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: localization problem @ 2006-08-13 17:52 Peter Eisentraut <peter_e@gmx.net> parent: j n <jneuschld@gmail.com> 0 siblings, 0 replies; 2+ messages in thread From: Peter Eisentraut @ 2006-08-13 17:52 UTC (permalink / raw) To: pgsql-admin; +Cc: j n <jneuschld@gmail.com> j n wrote: > can any1 point me to some tutorial what is needed to run localization > support ... There isn't much to tutor about. You pretty much have everything figured out. > than creating data directory > initdb --locale=sk_SK.utf8 /usr/local/pgsql/dataSK > > creating database : > createdb doctorko -U doctorko -E UTF8 This looks correct. > SHOW LC_COLLATE give output sk_SK If you initialized with locale sk_SK.utf8 but lc_collate shows sk_SK, then something went wrong. > so everythink look ok but order still not working ... Check if the order is consistent with what you get with the "sort" command from the shell. If that doesn't help, show us the data. -- Peter Eisentraut http://developer.postgresql.org/~petere/ ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2006-08-13 17:52 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2006-08-12 18:55 localization problem j n <jneuschld@gmail.com> 2006-08-13 17:52 ` Peter Eisentraut <peter_e@gmx.net>
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