X-Original-To: pgsql-sql@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id A6DE2476285 for ; Fri, 25 Apr 2003 14:44:31 -0400 (EDT) Received: from mail.millsoft.ca (unknown [216.187.67.133]) by postgresql.org (Postfix) with ESMTP id E8A88475F16 for ; Fri, 25 Apr 2003 14:44:02 -0400 (EDT) Received: from ([24.78.132.76]) by mail.millsoft.ca (Merak 4.4.2) with SMTP id IYA36949; Fri, 25 Apr 2003 11:57:42 -0800 Date: Fri, 25 Apr 2003 11:44:40 -0700 To: pginfo Subject: Re: Fwd: Unicode, RedHat Linux, & PostgreSQL Content-Type: text/plain; charset=utf-8; format=flowed Cc: pgsql-sql@postgresql.org Reply-To: vernonw@gatewaytech.com References: <3EA91209.7252453B@t1.unisoftbg.com> From: Vernon Organization: NA MIME-Version: 1.0 Message-ID: In-Reply-To: <3EA91209.7252453B@t1.unisoftbg.com> User-Agent: Opera7.10/Win32 M2 build 2840 X-Spam-Status: No, hits=-32.5 required=5.0 tests=BAYES_01,EMAIL_ATTRIBUTION,IN_REP_TO,QUOTED_EMAIL_TEXT, REFERENCES,REPLY_WITH_QUOTES,USER_AGENT 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/384 X-Sequence-Number: 13085 Hi, Ivan, Thanks for your input. Is the "EUC_JP" for the output of the command "select pg_encoding_to_char(1)"? And what are the string encoding for user input data and data retrieved from DB? What is your programming language? Vernon On Fri, 25 Apr 2003 12:46:33 +0200, pginfo wrote: > 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 > > > > -- Vernon