Unicode, RedHat Linux, & PostgreSQL

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

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:

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 <pginfo@t1.unisoftbg.com> 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 <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

--
Vernon