From: Troy <tjk@tksoft.com>
To: vernonw@gatewaytech.com
Cc: pgsql-sql@postgresql.org
Subject: Re: Fwd: Unicode, RedHat Linux, & PostgreSQL
Date: Sat, 26 Apr 2003 06:07:04 -0700 (PDT)
Message-ID: <200304261307.h3QD74ls029239@tksoft.com> (raw)
In-Reply-To: <no.id>
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
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: tjk@tksoft.com, vernonw@gatewaytech.com
Subject: Re: Fwd: Unicode, RedHat Linux, & PostgreSQL
In-Reply-To: <200304261307.h3QD74ls029239@tksoft.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox