Big5 contains '\'

Limin Liu <limin@pumpkinnet.com>

From: Limin Liu <limin@pumpkinnet.com>
To: pgsql-hackers@postgresql.org, pgsql-general@postgresql.org, limin@pumpkinnet.com
Date: 2001-06-12T18:18:54Z
Lists: pgsql-hackers

Attachments

Hi,

My project requires to use Big5/EUC_TW (two bytes per
chinese-character).

Unfortunately, Big5 code contains escape '\'.
For instance,
1: create table "¦¨¥\ªº¤@¥b" (n int, m text);
2: create table n (n int, m text);
3: insert into n values (19,'¦nªº¶}©l¬O¦¨¥\ªº¤@¥b');  -- 10 chinese
characters
4: select * from n;
 n  |          m
----+----------------------
 15 | ¦nªº¶}©l¬O¦¨¥ªº¤@¥b

Table name in line 1 is ¦¨¥\ªº¤@¥b.  With ", there is no problem.  Line
3 tries to insert a value with escape '\'.  I realized this '\' is
gone.  Of course, what we see are totally nonsense after the 6th
character.

This can be fixed by creating a MULTIBYTE block in scansup.c (see
attachment).  Can you put this in the next release if there is no
objection (or bugs).  :-)

I am thinking about to write an introduction book for PostgreSQL in
chinese (big5).  With this problem, it will be hard to convince them to
use PostgreSQL.

--
Regards,
Limin Liu