Received: from localhost.localdomain (postgresql.org [64.49.215.8]) by localhost (Postfix) with ESMTP id 36B2D476473 for ; Tue, 11 Jun 2002 11:22:51 -0400 (EDT) Received: from goliath.sylaba.poznan.pl (goliath.sylaba.poznan.pl [195.216.104.3]) by postgresql.org (Postfix) with ESMTP id C90764763BC for ; Tue, 11 Jun 2002 11:19:29 -0400 (EDT) Received: by goliath.sylaba.poznan.pl (8.11.6/8.10.1) id g5BFJYu29563 for pgsql-sql@postgresql.org.KAV; Tue, 11 Jun 2002 17:19:34 +0200 (CEST) Received: from venus.local.navi.pl (ps103.poznan.sdi.tpnet.pl [217.97.72.103]) by goliath.sylaba.poznan.pl (8.11.6/8.10.1) with ESMTP id g5BFJXp29555 for ; Tue, 11 Jun 2002 17:19:33 +0200 (CEST) Received: from venus.local.navi.pl (venus.local.navi.pl [192.168.1.10]) by venus.local.navi.pl (8.11.6/8.11.6) with ESMTP id g5BFJtY04672 for ; Tue, 11 Jun 2002 17:19:55 +0200 Subject: Unicode and escaping single quotes From: Olaf =?iso-8859-2?Q?Fr=B1czyk?= To: pgsql-sql@postgresql.org Content-Type: text/plain Content-Transfer-Encoding: 7bit X-Mailer: Ximian Evolution 1.0.3 (1.0.3-4) Date: 11 Jun 2002 17:19:55 +0200 Message-Id: <1023808795.1622.19.camel@venus> Mime-Version: 1.0 X-Archive-Number: 200206/130 X-Sequence-Number: 8095 Hi, 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. Please CC me. Best Regards, Olaf Fraczyk