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 BC0559FA682 for ; Sat, 12 Aug 2006 15:55:46 -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 38709-05 for ; Sat, 12 Aug 2006 15:55:43 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from py-out-1112.google.com (py-out-1112.google.com [64.233.166.179]) by postgresql.org (Postfix) with ESMTP id 4B3A39FA5CE for ; Sat, 12 Aug 2006 15:55:43 -0300 (ADT) Received: by py-out-1112.google.com with SMTP id n25so616618pyg for ; Sat, 12 Aug 2006 11:55:42 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:mime-version:content-type; b=ZCStr6xVAD05gatKFSkgv7vLc9nQrLYvZhZWvISfowPIZSRmS4MPA7lMnBqa/zqifQ98m5YKoX4i5jiMY4PL9UzuXMx8eU6obisNSp7Xy8wIySFuMDlcc+j5Erbas4y5oM3S2LLo0A+NBFucS4Fy8jtjWZNpj3DiQOXZFhyiRdc= Received: by 10.65.59.16 with SMTP id m16mr5399407qbk; Sat, 12 Aug 2006 11:55:42 -0700 (PDT) Received: by 10.64.53.3 with HTTP; Sat, 12 Aug 2006 11:55:41 -0700 (PDT) Message-ID: <46f93e0d0608121155w14d14e32g51b0436fb2494a70@mail.gmail.com> Date: Sat, 12 Aug 2006 20:55:41 +0200 From: "j n" To: pgsql-admin@postgresql.org Subject: localization problem MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_34271_9318183.1155408941930" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=1.551 tagged_above=0 required=5 tests=DNS_FROM_RFC_ABUSE, HTML_10_20, HTML_MESSAGE, SPF_PASS X-Spam-Level: * X-Archive-Number: 200608/154 X-Sequence-Number: 22697 ------=_Part_34271_9318183.1155408941930 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline 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 ------=_Part_34271_9318183.1155408941930 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline 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
------=_Part_34271_9318183.1155408941930--