| From: | Limin Liu <limin(at)pumpkinnet(dot)com> |
|---|---|
| To: | pgsql-hackers(at)postgresql(dot)org, pgsql-general(at)postgresql(dot)org, limin(at)pumpkinnet(dot)com |
| Subject: | Re: Big5 contains '\' |
| Date: | 2001-06-12 20:31:04 |
| Message-ID: | 3B267C08.DEB283AE@pumpkinnet.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-hackers |
> Unfortunately, Big5 code contains escape '\'.
> For instance,
> 1: create table "¦¨¥\ªº¤(at)¥b" (n int, m text);
> 2: create table n (n int, m text);
> 3: insert into n values (19,'¦nªº¶}©l¬O¦¨¥\ªº¤(at)¥b'); -- 10 chinese
> characters
> 4: select * from n;
> n | m
> ----+----------------------
> 15 | ¦nªº¶}©l¬O¦¨¥ªº¤(at)¥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¦¨¥\ªº¤(at)¥b \t \\t \\\try \\\\test2');
select * from n;
n | m
----+----------------------
21 | ¦nªº¶}©l¬O¦¨¥\ªº¤(at)¥b \t \ ry \\test2
--
Regards,
Limin Liu
| Attachment | Content-Type | Size |
|---|---|---|
| scansup.c | application/octet-stream | 3.2 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Gregory Wood | 2001-06-12 20:31:18 | Re: very big problem with NULL |
| Previous Message | Michael Dunn | 2001-06-12 20:29:08 | PLPGSQL: Using SELECT INTO and EXECUTE |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2001-06-12 20:31:26 | Re: Australian timezone configure option |
| Previous Message | Tom Lane | 2001-06-12 20:26:17 | Re: Patch to include PAM support... |