Received: from localhost.localdomain (postgresql.org [64.49.215.8]) by localhost (Postfix) with ESMTP id 5353C475873 for ; Wed, 12 Jun 2002 02:02:06 -0400 (EDT) Received: from sraigw.sra.co.jp (sraigw.sra.co.jp [202.32.10.2]) by postgresql.org (Postfix) with ESMTP id D96D9475451 for ; Wed, 12 Jun 2002 02:02:03 -0400 (EDT) Received: from srascb.sra.co.jp (srascb [133.137.8.65]) by sraigw.sra.co.jp (8.9.3/3.7W-sraigw) with ESMTP id PAA31822; Wed, 12 Jun 2002 15:02:01 +0900 (JST) Received: (from root@localhost) by srascb.sra.co.jp (8.11.6/8.11.6) id g5C61iL33032; Wed, 12 Jun 2002 15:01:44 +0900 (JST) (envelope-from t-ishii@sra.co.jp) Received: from sranhm.sra.co.jp (sranhm [133.137.170.62]) by srascb.sra.co.jp (8.11.6/8.11.6av) with ESMTP id g5C61iV33024; Wed, 12 Jun 2002 15:01:44 +0900 (JST) (envelope-from t-ishii@sra.co.jp) Received: from localhost (IDENT:t-ishii@srapc1474.sra.co.jp [133.137.170.59]) by sranhm.sra.co.jp (8.9.3+3.2W/3.7W-srambox) with ESMTP id PAA30183; Wed, 12 Jun 2002 15:02:00 +0900 Date: Wed, 12 Jun 2002 15:01:56 +0900 (JST) Message-Id: <20020612.150156.58431751.t-ishii@sra.co.jp> To: olaf@cbk.poznan.pl Cc: pgsql-sql@postgresql.org Subject: Re: Unicode and escaping single quotes From: Tatsuo Ishii In-Reply-To: <1023808795.1622.19.camel@venus> References: <1023808795.1622.19.camel@venus> 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=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200206/141 X-Sequence-Number: 8106 > I want to put unicode text. > But in INSERT I have to escape ' (single quote character). > Should I escape every BYTE which has the value of ASCII single quote > character, or only real single quote characters (in unicode) - if I have > a multibyte unicode character, it may be composed (looking at the string > as an array of bytes) of a normal character and single quote character. PostgreSQL accepts only UTF-8 encoding, which never has the value of single quote except the ASCII real single quote. -- Tatsuo Ishii