Re: Special characters

"Mihai Gheorghiu" <tanethq@earthlink.net> writes:

> Yet another newbie question...
> The database I'm working on will have fields with special characters: CR/LF,
> ' (like in O'Malley) etc.
> Is there an easy way to deal with this (in INSERT, UPDATE and SELECT), or
> should the front end application (Java) take care of escaping those
> characters?

If you use PreparedStatements, the JDBC driver will quote and escape
the arguments appropriately.  If you don't, and build your SQL on the
fly, you'll have to do it yourself.

-Doug
--
Free Dmitry Sklyarov!
http://www.freesklyarov.org/

We will return to our regularly scheduled signature shortly.