X-Original-To: pgsql-sql@postgresql.org
Received: from spampd.localdomain (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id 7AD78475C3D
	for <pgsql-sql@postgresql.org>; Sat, 26 Apr 2003 09:08:34 -0400 (EDT)
Received: from gyw.com (gyw.com [209.55.67.177])
	by postgresql.org (Postfix) with ESMTP id 6D934474E42
	for <pgsql-sql@postgresql.org>; Sat, 26 Apr 2003 09:08:03 -0400 (EDT)
Received: from spi.tksoft.com (smtp3.tksoft.com [192.168.50.56])
	by gyw.com (8.12.9/8.12.8) with ESMTP id h3QD8cqa010799
	for <pgsql-sql@postgresql.org>; Sat, 26 Apr 2003 06:08:40 -0700
Received: from tksoft.com (tksoft.com [127.0.0.1])
	by spi.tksoft.com (8.12.8/8.12.8) with ESMTP id h3QD7D9i029240;
	Sat, 26 Apr 2003 06:07:13 -0700
Received: (from tjk@tksoft.com)
	by tksoft.com (8.12.8/8.12.8/Submit) id h3QD74ls029239;
	Sat, 26 Apr 2003 06:07:04 -0700
Message-Id: <200304261307.h3QD74ls029239@tksoft.com>
Subject: Re: Fwd: Unicode, RedHat Linux, & PostgreSQL
To: vernonw@gatewaytech.com
Date: Sat, 26 Apr 2003 06:07:04 -0700 (PDT)
Cc: pgsql-sql@postgresql.org
Reply-To: tjk@tksoft.com (Troy K.), <tjk@tksoft.com>
In-Reply-To: <no.id> from "Vernon" at Apr 24, 2003 11:40:25 AM
From: "Troy" <tjk@tksoft.com>
X-Info: None
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Spam-Status: No, hits=-13.6 required=5.0
	tests=BAYES_01,IN_REP_TO,QUOTED_EMAIL_TEXT,QUOTE_TWICE_1
	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/395
X-Sequence-Number: 13096

Vernon,

The language doesn't matter when using CJK (Chinese/Japanese/Korean)
data. The important issue is encoding. All language specific processing 
is best done in your own custom functions or in the calling program.
In my experience locales can be messy and cause problems, unless
you only use a single language and encoding for everything. 

Probably the best encoding to use is UTF-8. If your data is in real
unicode, you need to convert it to UTF-8. The problem with unicode and 
most legacy systems is that there can be 0x00 bytes within the data.
UTF-8 doesn't have this problem. 

Be aware that your programming environment (java for example) or
OS could have a slightly modified version of Unicode/UTF-8, so you
need to take that into consideration when transfering data between
systems. As far as I know, only the 0x00 is processed differently.
You need to check this out for your specific environments. 

I hope that helps.


Troy



> 
> Anyone?
> 
> ------- Forwarded message -------
> From: Vernon <vernonw@gatewaytech.com>
> 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
>