I'm executing several SQL commands on my msi database for certain repetitive task. e.g
UPDATE Feature SET Title='paracha3' WHERE Feature='TopLevel'
and this works fine. The problem is when i want to send some french characters that have single quote character (' ) as part of text e.g
UPDATE Feature SET Title='para'cha3' WHERE Feature='TopLevel'
This fails and i have tried \' and \\' inplace of ' character but nothing seem to work. Question is how do i send something like these characters?? Can anyone help.
Thank you all.
paracha3