Re: Fwd: Unicode, RedHat Linux, & PostgreSQL

From: Vernon <vernonw(at)gatewaytech(dot)com>
To: pginfo <pginfo(at)t1(dot)unisoftbg(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Fwd: Unicode, RedHat Linux, & PostgreSQL
Date: 2003-04-25 18:44:40
Message-ID: oprn67oqnpvu4si3@mail.bluesoft.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-sql


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(at)t1(dot)unisoftbg(dot)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(at)gatewaytech(dot)com>
>> To: pgsql-general(at)postgresql(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message elein 2003-04-25 18:57:02 Re: [SQL] rewriting values with before trigger
Previous Message mallah 2003-04-25 18:21:09 Re: Postgres client/server parameters?

Browse pgsql-sql by date

  From Date Subject
Next Message elein 2003-04-25 18:57:02 Re: [SQL] rewriting values with before trigger
Previous Message Ian Barwick 2003-04-25 18:10:11 Re: sorting chinese characters