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
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-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

Browse pgsql-hackers by date

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

Browse pgsql-odbc by date

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