pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedUnicode, RedHat Linux, & PostgreSQL
5+ messages / 3 participants
[nested] [flat]
* Unicode, RedHat Linux, & PostgreSQL
@ 2003-04-24 04:18 Vernon <vernonw@gatewaytech.com>
2003-04-24 18:40 ` Fwd: Unicode, RedHat Linux, & PostgreSQL Vernon <vernonw@gatewaytech.com>
0 siblings, 1 reply; 5+ messages in thread
From: Vernon @ 2003-04-24 04:18 UTC (permalink / raw)
To: pgsql-general@postgresql.org
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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Fwd: Unicode, RedHat Linux, & PostgreSQL
2003-04-24 04:18 Unicode, RedHat Linux, & PostgreSQL Vernon <vernonw@gatewaytech.com>
@ 2003-04-24 18:40 ` Vernon <vernonw@gatewaytech.com>
2003-04-25 10:46 ` Re: Fwd: Unicode, RedHat Linux, & PostgreSQL pginfo <pginfo@t1.unisoftbg.com>
0 siblings, 1 reply; 5+ messages in thread
From: Vernon @ 2003-04-24 18:40 UTC (permalink / raw)
To: pgsql-sql
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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Fwd: Unicode, RedHat Linux, & PostgreSQL
2003-04-24 04:18 Unicode, RedHat Linux, & PostgreSQL Vernon <vernonw@gatewaytech.com>
2003-04-24 18:40 ` Fwd: Unicode, RedHat Linux, & PostgreSQL Vernon <vernonw@gatewaytech.com>
@ 2003-04-25 10:46 ` pginfo <pginfo@t1.unisoftbg.com>
2003-04-25 18:44 ` Re: Fwd: Unicode, RedHat Linux, & PostgreSQL Vernon <vernonw@gatewaytech.com>
0 siblings, 1 reply; 5+ messages in thread
From: pginfo @ 2003-04-25 10:46 UTC (permalink / raw)
To: vernonw@gatewaytech.com; +Cc: pgsql-sql
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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Fwd: Unicode, RedHat Linux, & PostgreSQL
2003-04-24 04:18 Unicode, RedHat Linux, & PostgreSQL Vernon <vernonw@gatewaytech.com>
2003-04-24 18:40 ` Fwd: Unicode, RedHat Linux, & PostgreSQL Vernon <vernonw@gatewaytech.com>
2003-04-25 10:46 ` Re: Fwd: Unicode, RedHat Linux, & PostgreSQL pginfo <pginfo@t1.unisoftbg.com>
@ 2003-04-25 18:44 ` Vernon <vernonw@gatewaytech.com>
0 siblings, 0 replies; 5+ messages in thread
From: Vernon @ 2003-04-25 18:44 UTC (permalink / raw)
To: pginfo <pginfo@t1.unisoftbg.com>; +Cc: 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@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
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: Fwd: Unicode, RedHat Linux, & PostgreSQL
@ 2003-04-26 13:07 Troy <tjk@tksoft.com>
0 siblings, 0 replies; 5+ messages in thread
From: Troy @ 2003-04-26 13:07 UTC (permalink / raw)
To: vernonw@gatewaytech.com; +Cc: pgsql-sql
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
>
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2003-04-26 13:07 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2003-04-24 04:18 Unicode, RedHat Linux, & PostgreSQL Vernon <vernonw@gatewaytech.com>
2003-04-24 18:40 ` Vernon <vernonw@gatewaytech.com>
2003-04-25 10:46 ` pginfo <pginfo@t1.unisoftbg.com>
2003-04-25 18:44 ` Vernon <vernonw@gatewaytech.com>
2003-04-26 13:07 Re: Fwd: Unicode, RedHat Linux, & PostgreSQL Troy <tjk@tksoft.com>
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