Received: from sraigw.sra.co.jp (sraigw.sra.co.jp [202.32.10.2]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f0N14U089834 for ; Mon, 22 Jan 2001 20:04:30 -0500 (EST) (envelope-from t-ishii@sra.co.jp) Received: from sranhk.sra.co.jp (sranhk [133.137.36.134]) by sraigw.sra.co.jp (8.8.7/3.7W-sraigw) with ESMTP id KAA06274 for ; Tue, 23 Jan 2001 10:04:24 +0900 (JST) Received: from localhost (IDENT:t-ishii@srapc1474 [133.137.36.84]) by sranhk.sra.co.jp (8.9.3/3.7W-srambox) with ESMTP id KAA28158; Tue, 23 Jan 2001 10:04:19 +0900 To: pgman@candle.pha.pa.us Cc: cch@cc.kmu.edu.tw, pgsql-patches@postgresql.org Subject: Re: A Patch for MIC to EUC_TW code converting in mb support In-Reply-To: <200101222221.RAA12775@candle.pha.pa.us> References: <20001109134325L.t-ishii@sra.co.jp> <200101222221.RAA12775@candle.pha.pa.us> X-Mailer: Mew version 1.94.2 on Emacs 20.7 / Mule 4.1 =?iso-2022-jp?B?KBskQjAqGyhCKQ==?= Mime-Version: 1.0 Content-Type: Text/Plain; charset=us-ascii Content-Transfer-Encoding: 7bit Message-Id: <20010123100412W.t-ishii@sra.co.jp> Date: Tue, 23 Jan 2001 10:04:12 +0900 From: Tatsuo Ishii X-Dispatcher: imput version 20000228(IM140) Lines: 62 X-Archive-Number: 200101/91 X-Sequence-Number: 249 > Tatsuo, I assume these are all done in 7.1, right? Yes. -- Tatsuo Ishii > > > ============================================================================ > > > > > > POSTGRESQL BUG REPORT: MIC to EUC_TW code converting in mb support > > > ============================================================================ > > > > > > System Configuration > > > --------------------- > > > Architecture (example: Intel Pentium) :x86 > > > Operating System (example: Linux 2.0.26 ELF) :Linux 2.2.x and FreeBSD > > > 3.5R > > > PostgreSQL version (example: PostgreSQL-7.0) :PostgreSQL-7.0.2 > > > Compiler used (example: gcc 2.8.0) :egcs-2.91.66, gcc 2.7.3 > > > > > > A FULL description of the problem: > > > ------------------------------------------------ > > > In PostgreSQL mb (multi-byte) support, there is a bug in code converting > > > > > > for MIC to EUC_TW. Original mic2euc_tw() in conv.c converts CNS > > > 11643-1992 > > > Plane 2 into 2 bytes EUC_TW encoding. But characters in CNS 11643-1992 > > > Plane 2 > > > should be converted into 4 bytes EUC_TW encoding instead. > > > > > > A way to repeat the problem: > > > ---------------------------------------------------------------------- > > > When you initdb with -E EUC_TW and set PGCLIENTENCODING to BIG5, > > > you will find all the characters in CNS 11643-1992 Plane 2 are > > > incorrectly stored or output. > > > > > > This problem might be fixed by the solution in the attachement. > > > > Thanks for pointing it out. Your fix seems correct. > > > > BTW I have found another bug with EUC_TW support. line 917 in conv.c: > > > > *p++ = c1 - LC_CNS11643_3 + 0xa3; > > > > this should be: > > > > *p++ = *mic++ - LC_CNS11643_3 + 0xa3; > > > > Otherwise, CNS 11643-1992 Plane 3 or more won't work. Could you test > > it out with CNS 11643-1992 Plane 3 or more? > > > > If they are ok, I will fix the current source and make a patch for > > 7.0.3 (I guess it's too late to back-patch the 7.0 tree). > > -- > > Tatsuo Ishii > > > > > -- > Bruce Momjian | http://candle.pha.pa.us > pgman@candle.pha.pa.us | (610) 853-3000 > + If your life is a hard drive, | 830 Blythe Avenue > + Christ can be your backup. | Drexel Hill, Pennsylvania 19026