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.
Joined: Feb 10, 2001
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 !!!