Re: Symbol problem

* Bogdan Paduraru <bpaduraru(at)petar(dot)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(at)wintelcom(dot)net|alfred(at)freebsd(dot)org]
"I have the heart of a child; I keep it in a jar on my desk."