Re: 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-12T20:31:04Z
Lists: pgsql-hackers
Attachments
- scansup.c (application/octet-stream)
> 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 > My previous approach was not able to provide scape-escape. I.e. "\\t" will remain as "\\t". Here is the new update. I tried the following... It looks fine on all cases. insert into n values (21,'¦nªº¶}©l¬O¦¨¥\ªº¤@¥b \t \\t \\\try \\\\test2'); select * from n; n | m ----+---------------------- 21 | ¦nªº¶}©l¬O¦¨¥\ªº¤@¥b \t \ ry \\test2 -- Regards, Limin Liu