X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 931159DC80D for ; Tue, 17 Jan 2006 02:32:40 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 38870-08 for ; Tue, 17 Jan 2006 02:32:38 -0400 (AST) X-Greylist: delayed 00:20:25.059939 by SQLgrey- Received: from mailer.eglobalreach.net (mailer.eglobalreach.net [202.124.128.22]) by postgresql.org (Postfix) with ESMTP id 6F1159DC807 for ; Tue, 17 Jan 2006 02:32:36 -0400 (AST) Received: from ghwk02002147 (localhost [127.0.0.1] (may be forged)) by mailer.eglobalreach.net (8.11.6p2/) with ESMTP id k0H6CAH26811 for ; Tue, 17 Jan 2006 14:12:10 +0800 From: "Christian Paul B. Cosinas" To: Subject: Characters that needs escape characters when inserting to database Date: Tue, 17 Jan 2006 14:21:25 -0800 Message-ID: <00fc01c61bb4$5ae92590$1e21100a@ghwk02002147> MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Mailer: Microsoft Office Outlook 11 In-Reply-To: <0IT70020VVHQZ391@VL-MO-MR003.ip.videotron.ca> X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1506 Thread-Index: AcYbDru/Ug2/akUaSgufaXGIY/Ep6gABLjbAACgiFtA= X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=2.316 required=5 tests=[DATE_IN_FUTURE_12_24=2.316] X-Spam-Score: 2.316 X-Spam-Level: ** X-Archive-Number: 200601/104 X-Sequence-Number: 23893 Hi, Can anyone give me a list of characters that needs to be preceded by an escape character before inserting to database. Aside from characters listed below what are the other characters? "\" "'" Thanks I choose Polesoft Lockspam to fight spam, and you? http://www.polesoft.com/refer.html