Re: [PATCHES] A Patch for MIC to EUC_TW code converting inmbsupport

From: Chih-Chang Hsieh <cch(at)cc(dot)kmu(dot)edu(dot)tw>
To: Tatsuo Ishii <t-ishii(at)sra(dot)co(dot)jp>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: [PATCHES] A Patch for MIC to EUC_TW code converting inmbsupport
Date: 2000-11-15 01:16:58
Message-ID: 3A11E40A.47E528D@cc.kmu.edu.tw
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs pgsql-hackers pgsql-patches

Tatsuo Ishii 寫道:

> > For example: If we initdb -E MULE_INTERNAL first,
> > SET CLIENT_ENCODING TO 'BIG5', and
> > INSERT INTO some_table VALUES (..., 'the last byte of some Big5 char is
> > backslash\',...),
> > then we can not successfully complete this SQL INSERT -- the prompt of psql
> > changes
>
> Hum. initdb -E MULE_INTERNAL should work as well. Let me dig into the
> problem. It would be nice if you could send me the Big5 data for
> testing by a private mail.
> BTW I would not recommend "SET CLIENT_ENCODING TO 'BIG5'" to do an
> on-the-fly encoding changes. Since in this way, frontend side has no
> idea what the client encoding is. 7.0.x overcome this problem by
> introducing new \encoding command. For 6.5 or before I would recommend
> to use PGCLIENTENCODING environment variable.

You are right! When I do \encoding BIG5, it works.
But it seems that "\encoding" can only be issued in
psql's command prompt or be done with
PQsetClientEncoding() in libpq.

If our application for input is written in PHP (4.0.2)
How do we notify PostgreSQL that the frontend encoding
is 'BIG5' ? (pg_exec("\encoding BIG5") failed.)
PostgreSQL 7.1 will support automatic code conversion for
BIG5 to utf-8. Does it means that we do not have to
announce client encoding as long as the backend is utf-8?

I have also tried to set the environment variable
PGCLIENTENCODING to 'BIG5'. But when I execute
psql and then issue \encoding, it shows 'SQL_ASCII' in 7.0.2.
Is this environment variable useless in 7.0.x and latter?

Thank you so much for a newbie!
--
Chih-Chang Hsieh

In response to

Responses

Browse pgsql-docs by date

  From Date Subject
Next Message netad24 2000-11-15 14:19:16 aktuelle Viruswarnung - BITTE BEACHTEN
Previous Message Tatsuo Ishii 2000-11-14 05:54:34 Re: [PATCHES] A Patch for MIC to EUC_TW code converting in mbsupport

Browse pgsql-hackers by date

  From Date Subject
Next Message Larry Rosenman 2000-11-15 02:44:05 Re: Syslog Facility Patch
Previous Message Hiroshi Inoue 2000-11-15 01:12:22 Re: SearchSysCacheTuple(Copy)

Browse pgsql-patches by date

  From Date Subject
Next Message Peter Eisentraut 2000-11-15 20:23:24 Re: got Postgresql working on FreeBSD-alpha
Previous Message Alfred Perlstein 2000-11-14 23:06:33 Re: got Postgresql working on FreeBSD-alpha