Hi Guys, How Can I add a data in my backend that contains a single quote, cauze single quotes signifies the end of a string data in sql query. for eg. I want to insert the data "How're you" how can i do this. I have tried with PreparedStatement but it doesn't work for me. If you know something about this plz post the reply.... Thankz...
Hi!! If U use Oracle try like this insert into trial values('how''re u'); Like this put douuble single Quotes in where u need a single quotes within a string.Like this try in prepared stat.If not get it let me know. Sorry i don't know SQLSERVER BestWishes, chandran
if u r using 'Statement' to execute ur queries then it wont insert ur queries...if it containd special characters.. for that u will need to use .. PreparedStatement class and use the various set methods in this class .. hope it will solve ur problem..
Joined: Apr 17, 2001
Hi Guys, Thankz for replying me.....
subject: How Can I add a data in my backend that contains a single quote?