SQL Insert Problem

[Johny Lee]

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]

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.

        String textFromUser = "I'm not doing this";
        textFromUser = textFromUser.replaceAll("'", "\\'");

In future, put your questions to relevant forums

[Paul Clapham]

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

String insert = "INSERT into flummery ('" + name + "')";

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.