Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id AF2F647656F for ; Mon, 28 Oct 2002 09:22:48 -0500 (EST) Received: from sraigw.sra.co.jp (sraigw.sra.co.jp [202.32.10.2]) by postgresql.org (Postfix) with ESMTP id DB91C476543 for ; Mon, 28 Oct 2002 09:22:46 -0500 (EST) Received: from srascb.sra.co.jp (srascb [133.137.8.65]) by sraigw.sra.co.jp (Postfix) with ESMTP id 53796625EF; Mon, 28 Oct 2002 23:22:50 +0900 (JST) Received: from sranhm.sra.co.jp (IDENT:root@localhost [127.0.0.1]) by srascb.sra.co.jp (8.9.3/3.7W-sra) with ESMTP id XAA09569; Mon, 28 Oct 2002 23:22:50 +0900 Received: from localhost (localhost [127.0.0.1]) by sranhm.sra.co.jp (8.9.3+3.2W/3.7W-srambox) with ESMTP id XAA10590; Mon, 28 Oct 2002 23:22:50 +0900 Date: Mon, 28 Oct 2002 23:21:43 +0900 (JST) Message-Id: <20021028.232143.45508822.t-ishii@sra.co.jp> To: timtimccy@hotmail.com Cc: pgsql-hackers@postgresql.org Subject: Re: How to store chinese using the Postgresql? From: Tatsuo Ishii In-Reply-To: References: X-Mailer: Mew version 2.2 on Emacs 20.7 / Mule 4.1 =?iso-2022-jp?B?KBskQjAqGyhCKQ==?= Mime-Version: 1.0 Content-Type: Text/Plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200210/1245 X-Sequence-Number: 31014 > i would like to use postgresql to store any data (some include chinese), but when i access the chinese data in postgresql, i can't get back correct data, it return any unknow word/data to me. > How can i solve it? i am using the RedHat Linux 7.2 and Postgresql 7.1, and i haven't install CLE on Linux. Define "chinese." What character set for Chinese are you using? -- Tatsuo Ishii