X-Original-To: pgsql-interfaces-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id 96191D1C4D6 for ; Mon, 11 Aug 2003 08:09:56 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 66053-02 for ; Mon, 11 Aug 2003 05:08:28 -0300 (ADT) Received: from druid.net (druid.net [216.126.72.98]) by svr1.postgresql.org (Postfix) with ESMTP id E5F6AD1C4B9 for ; Mon, 11 Aug 2003 05:09:45 -0300 (ADT) Received: by druid.net (Postfix, from userid 1000) id 757531A6E; Mon, 11 Aug 2003 04:09:48 -0400 (EDT) From: "D'Arcy J.M. Cain" Reply-To: darcy@PyGreSQL.org To: "Alastair G. Hogge" , pgsql-interfaces@postgresql.org Subject: Re: Punctuation problems. Date: Mon, 11 Aug 2003 04:09:47 -0400 User-Agent: KMail/1.5.2 References: <200308102355.25991.agh@tpg.com.au> In-Reply-To: <200308102355.25991.agh@tpg.com.au> Organization: PyGreSQL Development Group MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200308110409.47445.darcy@PyGreSQL.org> X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200308/43 X-Sequence-Number: 4397 On Sunday 10 August 2003 09:55, Alastair G. Hogge wrote: > I'm using PyGreSQL to access my database to store information gathered from > HTML forms (using CGI). However I've run into a problem with some of the > data retrived. > > For example say a user of my HTML form inputs their name "Eick O'Shae". > Now when I try to store that I get problems due the ' I think. Is there a > way I can store and ' in the DB? Also are there other symbols should be > aware of, and can I store them also? This email probably isn't making much > sense as I'm very tired and have been looking at this screen for hours, but > any help would great. Are you using the "Classic" interface of the "DB-API" interface? Note that PyGreSQL has its own list. You can get more information at http://www.PyGreSQL.org. -- D'Arcy J.M. Cain PyGreSQL Development Group http://www.PyGreSQL.org