X-Original-To: pgsql-sql@postgresql.org Received: from sraigw.sra.co.jp (sraigw.sra.co.jp [202.32.10.2]) by postgresql.org (Postfix) with ESMTP id 56225474E4F for ; Tue, 18 Mar 2003 02:48:23 -0500 (EST) Received: from srascb.sra.co.jp (srascb [133.137.8.65]) by sraigw.sra.co.jp (Postfix) with ESMTP id 906876240D; Tue, 18 Mar 2003 16:48:23 +0900 (JST) Received: from sranhm.sra.co.jp (IDENT:root@localhost [127.0.0.1]) by srascb.sra.co.jp (8.9.3/3.7W-sra) with ESMTP id QAA29856; Tue, 18 Mar 2003 16:48:23 +0900 Received: from localhost (IDENT:t-ishii@srapc1977.sra.co.jp [133.137.170.63]) by sranhm.sra.co.jp (8.9.3+3.2W/3.7W-srambox) with ESMTP id QAA24111; Tue, 18 Mar 2003 16:48:23 +0900 Date: Tue, 18 Mar 2003 16:49:26 +0900 (JST) Message-Id: <20030318.164926.104032200.t-ishii@sra.co.jp> To: frankie@ucr.com.hk Cc: pgsql-sql@postgresql.org Subject: Re: PLPGSQL with Multibyte Issue From: Tatsuo Ishii In-Reply-To: References: X-Mailer: Mew version 2.2 on Emacs 20.7 / Mule 4.1 =?iso-2022-jp?B?KBskQjAqGyhCKQ==?= Mime-Version: 1.0 Content-Type: Text/Plain; charset=iso-2022-jp Content-Transfer-Encoding: 7bit X-Archive-Number: 200303/426 X-Sequence-Number: 12465 石井です. > I'm experiencing some problem with using multibyte character issues in > PLPGSQL. It seems > that some double characters to have value of '0x5c' in the lower byte, > making PLPGSQL to > think that the statement is a unterminatated string. And this drives me > crazy :( . What kind of database encoding are you using? -- Tatsuo Ishii