MySql error

[lahiru.vithanage]

database data pass karaddi, content ekak wage yawaddi eke tyena single quotation pass karanna bane error ekak enawanee.. please help

 

[kavindagk]

meka use kaloth 'value' kiyala thama add wenne , oyata oni widiyata '\' eka magin single quote add karanne pluwan (Escape character)

insert into <Yourtable> (<fieldname>) values ('\'value\'');

 

[MihiCherub]

single quotes 2k danna..
Ex - Nirmal's Cafe --> Nirmal''s Cafe
value.repleace.All(" ' ", " '' ")

 

[weechami]

string replace use karala (`)[<- string on ~key then no probs] mekata replace karanna

 

[lahiru.vithanage]

thanks okkotama