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?
E.g. The user searches for O'Malley in the lastname field.
Thank you,
Mihai Gheorghiu