Re: Fwd: Unicode, RedHat Linux, & PostgreSQL

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@xxxxxxxxxxxxxxxx> 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@xxxxxxxxxxxxxxx>
> > To: pgsql-general@xxxxxxxxxxxxxx
> > 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


---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster