X-Original-To: pgsql-sql@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id C331B475AE4 for ; Fri, 25 Apr 2003 07:49:33 -0400 (EDT) Received: from unimm.unisoftbg.com (unknown [194.12.229.207]) by postgresql.org (Postfix) with ESMTP id 31C8B474E42 for ; Fri, 25 Apr 2003 07:49:20 -0400 (EDT) Received: (qmail 13888 invoked by uid 507); 25 Apr 2003 11:50:50 -0000 Received: from unknown (HELO t1.unisoftbg.com) (pginfo%t1.unisoftbg.com@194.12.229.193) by 0 with SMTP; 25 Apr 2003 11:50:50 -0000 Message-ID: <3EA91209.7252453B@t1.unisoftbg.com> Date: Fri, 25 Apr 2003 12:46:33 +0200 From: pginfo X-Mailer: Mozilla 4.03 [en] (Win95; I) MIME-Version: 1.0 To: vernonw@gatewaytech.com Cc: pgsql-sql@postgresql.org Subject: Re: Fwd: Unicode, RedHat Linux, & PostgreSQL References: Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Spam-Status: No, hits=-29.3 required=5.0 tests=BAYES_01,EMAIL_ATTRIBUTION,QUOTED_EMAIL_TEXT,REFERENCES, REPLY_WITH_QUOTES autolearn=ham version=2.50 X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp) X-Archive-Number: 200304/369 X-Sequence-Number: 13070 Hi Vernon, I do not know about the Chinese, but I am using pg 7.3.1 + RH 7.3 and cyrillic and do not have problems with storing data. My linux (server) setting is as default (US). By db creating, I define it as unicode and it is working for me. You will have problems only with sorting. Is is very slow for unicode. regards, ivan. Vernon wrote: > Anyone? > > ------- Forwarded message ------- > From: Vernon > To: pgsql-general@postgresql.org > Subject: Unicode, RedHat Linux, & PostgreSQL > Date: Wed, 23 Apr 2003 21:18:23 -0700 > > > > > My project works on Window 2000, but not on Linux. The non-Western > > language, Chinese in this case, doesn't stored or/and retrieved properly > > in Linux. That differenc between the two configurations is only where > > PostgreSQL is setting: Window 2000 with Chinese locales, Redhat Linux > > 8.0. Does someone have a similar configuration and is able to have non- > > Western language stored and retrieved in PostgreSQL 7.2? > > > > Thanks for your input. > > > > -- > Vernon > > ---------------------------(end of broadcast)--------------------------- > TIP 6: Have you searched our list archives? > > http://archives.postgresql.org