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