Skip site navigation (1) Skip section navigation (2)

Re: UTF-8 support

From: "Serguei Mokhov" <sa_mokho(at)alcor(dot)concordia(dot)ca>
To: "Tatsuo Ishii" <t-ishii(at)sra(dot)co(dot)jp>
Cc: <jm(dot)poure(at)freesurf(dot)fr>, <pgsql-odbc(at)postgresql(dot)org>, <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: UTF-8 support
Date: 2001-09-24 03:05:17
Message-ID: 00b701c144a5$c0e4d780$5dd9fea9@gunn (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-odbc
----- Original Message ----- 
From: Tatsuo Ishii <t-ishii(at)sra(dot)co(dot)jp>
Sent: Sunday, September 23, 2001 10:47 PM

> > My question is now how many BE's/FE's would you return encodings for?
> 
> I don't quite understand your question. What I thought were something
> like this:
> 
> SELECT pg_available_encodings();
> pg_available_encodings
> ----------------------
> SQL_ASCII
> EUC_JP
> EUC_CN
> EUC_KR
> EUC_TW
> UNICODE
> MULE_INTERNAL
> LATIN1
> LATIN2
> LATIN3
> LATIN4
> LATIN5
> KOI8
> WIN
> ALT
> SJIS
> BIG5
> WIN1250

Which ones belong to the backend and which ones to the frontend?
Or even more: which ones belong to the backend, which ones
to the frontend #1, which ones to the frontend #2, etc...

For examle, I have two fronends:

FE1: UNICODE,  WIN1251
FE2: KOI8, UNICODE
BE: UNICODE, LATIN1, ALT

Which ones SELECT pg_available_encodings(); will show?
The ones of the BE and the FE making the request?

In case I need to communicate with BE using one common
encoding between the two if it is available.

> BTW, another question comes to my mind. Why don't we make available
> this kind of information by ordinaly tables or views, rather than by
> functions?  It would be more flexible and easy to use.

Sounds like a good idea, make another system table for encodings
and NLS stuff...

S.


In response to

Responses

pgsql-hackers by date

Next:From: bpalmerDate: 2001-09-24 04:18:49
Subject: LOCAL_CREDS -> SCM_CREDS in src/backend/libpq/auth.c:535
Previous:From: Hiroshi InoueDate: 2001-09-24 03:01:54
Subject: Re: an already existing alter table drop column ?!?!?!

pgsql-odbc by date

Next:From: Hiroshi InoueDate: 2001-09-24 05:25:49
Subject: Re: [ODBC] UTF-8 support
Previous:From: Tatsuo IshiiDate: 2001-09-24 02:47:31
Subject: Re: UTF-8 support

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group