> 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