I know this has been answered quite a few times, but I cant find it with the search. SO here it goes AGAIN.....

I want to save this text in my database

I'll go


but since it has the ' it sends me an error. I did the replace(str,"'","''") but that saves i''l go and I dont want that... I want I'll go

how can I do this?