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 9A07DD1C510 for ; Sun, 10 Aug 2003 13:55:37 +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 50746-08 for ; Sun, 10 Aug 2003 10:54:14 -0300 (ADT) Received: from mail3.tpgi.com.au (mail.tpgi.com.au [203.12.160.59]) by svr1.postgresql.org (Postfix) with ESMTP id 1F32CD1C7F3 for ; Sun, 10 Aug 2003 10:55:25 -0300 (ADT) Received: from 192.168.0.4 (220-244-72-6.tpgi.com.au [220.244.72.6]) by mail3.tpgi.com.au (8.11.6/8.11.6) with ESMTP id h7ADtQa18559 (using TLSv1/SSLv3 with cipher RC4-MD5 (128 bits) verified NO) for ; Sun, 10 Aug 2003 23:55:27 +1000 From: "Alastair G. Hogge" To: pgsql-interfaces@postgresql.org Subject: Punctuation problems. Date: Sun, 10 Aug 2003 23:55:25 +1000 User-Agent: KMail/1.5.3 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200308102355.25991.agh@tpg.com.au> X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=0.5 tagged_above=0.0 required=5.0 tests=RCVD_IN_UNCONFIRMED_DSBL, USER_AGENT_KMAIL X-Spam-Level: X-Archive-Number: 200308/41 X-Sequence-Number: 4395 Hello list, 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. Thanks -Al