Date: Sat, 27 Jan 2001 01:44:25 -0800
From: Alfred Perlstein <bright@wintelcom.net>
To: Bogdan Paduraru <bpaduraru@petar.ro>
Cc: pgsql-admin@postgresql.org
Subject: Re: Symbol problem
Message-ID: <20010127014425.L26076@fw.wintelcom.net>
References: <20010127083349.2592.qmail@web10011.mail.yahoo.com>
	<3A71E997.1030201@petar.ro>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
User-Agent: Mutt/1.2.5i
In-Reply-To: <3A71E997.1030201@petar.ro>;
	from bpaduraru@petar.ro on Fri, Jan 26, 2001 at 11:18:15PM +0200

* Bogdan Paduraru <bpaduraru@petar.ro> [010127 01:27] wrote:
> Hello ,
> I made a tool with Java servlets and Postgresql. This tool inputs html text
> into a db. My problem is that everytime I input text that contains  '  
> (apostrophe)
> I get an SQL exception.
> This Postgresql can't see by itself what is the difference ?
> I don't want to check every character, this is stupid. I'd rather change 
> the RDBMS.

Most every interface into postgresql has a 'quoting' mechanism that
will escape these characters for you.  Check the docs.

-- 
-Alfred Perlstein - [bright@wintelcom.net|alfred@freebsd.org]
"I have the heart of a child; I keep it in a jar on my desk."