Re: Symbol problem

* 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."