Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 789389FBBA6 for ; Wed, 25 Jul 2007 13:36:51 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 70178-01-2 for ; Wed, 25 Jul 2007 13:36:44 -0300 (ADT) X-Greylist: delayed 00:32:16.500936 by SQLgrey-1.7.5 Received: from mailer.gov.bf (unknown [212.52.129.92]) by postgresql.org (Postfix) with ESMTP id 99DEA9FBC57 for ; Wed, 25 Jul 2007 13:36:42 -0300 (ADT) Received: from mailer.gov.bf (mailer.gov.bf [212.52.129.92]) by mailer.gov.bf (Postfix) with ESMTP id F2CC81E7109 for ; Wed, 25 Jul 2007 13:28:44 -0400 (EDT) From: "Martial Elise KIBA" To: pgsql-admin@postgresql.org Subject: Localisation Date: Wed, 25 Jul 2007 17:28:44 +0000 Message-Id: <20070725171632.M46418@mailer.gov.bf> X-Mailer: Open WebMail 2.01 20030611 X-OriginatingIP: 212.52.128.7 (mkiba) MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 X-MailScanner-Information: Please contact the ISP for more information X-MailScanner: Found to be clean X-MailScanner-From: mkiba@delgi.gov.bf X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=1.368 tagged_above=0 required=5 tests=AWL=0.867, BAYES_50=0.001, RCVD_IN_WHOIS_INVALID=0.4, RDNS_NONE=0.1 X-Spam-Level: * X-Archive-Number: 200707/279 X-Sequence-Number: 26260 Hi all! I have a postgresql sever running on RedHat EL 4.0 Update 2. the following locales applies to my database: lc_messages = 'fr_FR.UTF-8' # locale for system error message # strings lc_monetary = 'fr_FR.UTF-8' # locale for monetary formatting lc_numeric = 'fr_FR.UTF-8' # locale for number formatting lc_time = 'fr_FR.UTF-8' # locale for time formatting But postgresql steal respond in english, and TO_CHAR(date, 'Day, DD Month YYYY') return a date in english Martial E. W. KIBA Ingénieur de Conception en Informatiques Option Génie-Logiciel Tél: (+226) 70 15 44 93 Mail: mkiba@delgi.gov.bf / mkiba01@yahoo.fr