File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes Web Services and the fly likes SQL Insert Problem Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Java » Web Services
Bookmark "SQL Insert Problem" Watch "SQL Insert Problem" New topic
Forums: Web Services JDBC and Relational Databases

SQL Insert Problem

Johny Lee

Joined: Dec 14, 2012
Posts: 4
I have column in my database which is client Remarks and it's defined as TEXT but I have been having errors whenever a client enters remarks such "I'm not doing this" but if a client enters "I am not doing this". It's fine. Please help. The error occurs whenever a client completes a form online on the website, coding was done with php and MySQL for the website.
Praful Thakare
Ranch Hand

Joined: Feb 10, 2001
Posts: 642
well this is not webservice question, but with 2 posts only you look new to JavaRanch.

replace all your special characters with escape sequence for mysql, i think it is \, so something like.

In future, put your questions to relevant forums

All desirable things in life are either illegal, banned, expensive or married to someone else !!!
Paul Clapham

Joined: Oct 14, 2005
Posts: 19973

Would I be correct in guessing that you are generating your SQL insert command by a Java string concatenation which looks something like this?

If so then you have the "O'Brien" problem. So stop doing that and use a PreparedStatement instead. Here's a link to the tutorial: Using Prepared Statements.
I agree. Here's the link:
subject: SQL Insert Problem
It's not a secret anymore!