File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
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


Win a copy of Head First Android this week in the Android forum!
JavaRanch » Java Forums » Java » Web Services
Bookmark "SQL Insert Problem" Watch "SQL Insert Problem" New topic
Forums: Web Services JDBC and Relational Databases
Author

SQL Insert Problem

Johny Lee
Greenhorn

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: 641
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
Sheriff

Joined: Oct 14, 2005
Posts: 19693
    
  10

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.
 
wood burning stoves
 
subject: SQL Insert Problem
 
jQuery in Action, 3rd edition