X-Original-To: pgsql-admin-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 11CBE9FB20F for ; Sun, 13 Aug 2006 14:52:19 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 64651-04 for ; Sun, 13 Aug 2006 14:52:18 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from mail.gmx.net (mail.gmx.de [213.165.64.20]) by postgresql.org (Postfix) with SMTP id 0257D9FB1BF for ; Sun, 13 Aug 2006 14:52:17 -0300 (ADT) Received: (qmail invoked by alias); 13 Aug 2006 17:52:16 -0000 Received: from dslb-084-063-111-189.pools.arcor-ip.net (EHLO colt.pezone.net) [84.63.111.189] by mail.gmx.net (mp001) with SMTP; 13 Aug 2006 19:52:16 +0200 X-Authenticated: #495269 From: Peter Eisentraut To: pgsql-admin@postgresql.org Subject: Re: localization problem Date: Sun, 13 Aug 2006 19:52:14 +0200 User-Agent: KMail/1.9.1 Cc: "j n" References: <46f93e0d0608121155w14d14e32g51b0436fb2494a70@mail.gmail.com> In-Reply-To: <46f93e0d0608121155w14d14e32g51b0436fb2494a70@mail.gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200608131952.14662.peter_e@gmx.net> X-Y-GMX-Trusted: 0 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200608/155 X-Sequence-Number: 22698 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/