Thread

1. Big5 contains '\'

   Limin Liu <limin@pumpkinnet.com> — 2001-06-12T18:18:54Z

   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
   
   
   

2. Re: Big5 contains '\'

   Limin Liu <limin@pumpkinnet.com> — 2001-06-12T20:31:04Z

   > 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
   

3. Re: Big5 contains '\'

   Tatsuo Ishii <t-ishii@sra.co.jp> — 2001-06-13T00:03:43Z

   > My project requires to use Big5/EUC_TW (two bytes per
   > chinese-character).
   > 
   > Unfortunately, Big5 code contains escape '\'.
   
   PostgreSQL can handle Big5 since 6.5. Create a database with the encoding
   EUC_TW, and set the client side encoding to BIG5. For example, set
   PGCLIENTENCODING envrionment variable to BIG5 before starting psql or
   any libpq based clients. For 7.0 or greater version of PostgreSQL, you
   could also use \encoding command in psql.
   --
   Tatsuo Ishii