Received: from localhost.localdomain (postgresql.org [64.49.215.8])
	by localhost (Postfix) with ESMTP id DD6F5476CAF
	for <pgsql-sql@postgresql.org>; Fri,  5 Jul 2002 15:20:32 -0400 (EDT)
Mailbox-Line: From vernonw@gatewaytech.com  Fri Jul  5 15:20:32 2002
Received: from pd3mo1so.prod.shaw.ca (h24-71-223-10.cg.shawcable.net
	[24.71.223.10]) by postgresql.org (Postfix) with ESMTP id 34C82476BFD
	for <pgsql-sql@postgresql.org>; Fri,  5 Jul 2002 14:30:33 -0400 (EDT)
Received: from pd3mr2so.prod.shaw.ca (pd3mr2so-ser.prod.shaw.ca
 [10.0.141.178])
	by l-daemon (iPlanet Messaging Server 5.1 HotFix 0.8 (built May 12
	2002))
	with ESMTP id <0GYS004I7GMY3C@l-daemon> for pgsql-sql@postgresql.org;
	Fri, 05 Jul 2002 12:28:10 -0600 (MDT)
Received: from pn2ml9so.prod.shaw.ca (pn2ml9so-qfe0.prod.shaw.ca [10.0.121.7])
	by l-daemon (iPlanet Messaging Server 5.1 HotFix 0.8 (built May 12
	2002))
	with ESMTP id <0GYS004Q8GMYJ7@l-daemon> for pgsql-sql@postgresql.org;
	Fri, 05 Jul 2002 12:28:10 -0600 (MDT)
Received: from kimiko (h24-78-152-126.vc.shawcable.net [24.78.152.126])
	by l-daemon (iPlanet Messaging Server 5.1 HotFix 0.8 (built May 12
	2002))
	with SMTP id <0GYS004O3GMXSH@l-daemon> for pgsql-sql@postgresql.org;
	Fri, 05 Jul 2002 12:28:10 -0600 (MDT)
Date: Fri, 05 Jul 2002 11:29:18 -0700
From: Vernon Wu <vernonw@gatewaytech.com>
Subject: i18n in pgSQL
To: pgsql-sql@postgresql.org
Reply-To: vernonw@gatewaytech.com
Message-id: <IDFXTMHNK4UO3XB64ZXGDYWPJVQUR.3d25e57e@kimiko>
MIME-version: 1.0
X-Mailer: Opera 6.03 build 1107
Content-type: text/plain; charset=iso-8859-1
Content-transfer-encoding: 7BIT
X-Priority: 2 (High)
X-Spam-Status: No, hits=0.0 required=5.0
	tests=none
	version=2.30
X-Spam-Level: 
X-Archive-Number: 200207/71
X-Sequence-Number: 8450


Hi,

I am working on an application intended for multilingual users. I have learnt from a source that I shall define double-byte 
data type such as nvarchar and ntext in DB. I don't see these data type in the pgsql online document. I have tried to 
create a table with the data type. The nvarchar is accepted, but not ntext. 

Also, I remember I can configure pgsql for unicode in Linux. I can't find what, where, and how to configure pgsql in my 
current setting: on cygwin.

Currently, Chinese charaters can't be stored and retrieved properly.

Thanks for your help.

Vernon