File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes Cattle Drive and the fly likes jdbc and apostrophes Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » This Site » Cattle Drive
Bookmark "jdbc and apostrophes " Watch "jdbc and apostrophes " New topic

jdbc and apostrophes

Pauline McNamara

Joined: Jan 19, 2001
Posts: 4012
For the jdbc assignments is it considered overkill to deal with titles, stars or descriptions with ' in the text? For example, a title like My Best Friend's Dog or a star like Rosie O'Donnell breaks the SQL. Should those ' be escaped first or does one KISS it off?

Marilyn de Queiroz

Joined: Jul 22, 2000
Posts: 9059
I think it is a good thing if your code can handle that situation, but it's not required to pass the assignment.

"Yesterday is history, tomorrow is a mystery, and today is a gift; that's why they call it the present." Eleanor Roosevelt
It is sorta covered in the JavaRanch Style Guide.
subject: jdbc and apostrophes
It's not a secret anymore!