I have to insert and delete some data using names that may contain single or double quotes.
INSERT INTO Table (Name,Value) VALUES (' "nameString" ', ' "valueString" ');
DELETE FROM Table WHERE Name= "nameString";
When nameString has a single Quote like, a'mbuli, then I replace the single quote with two single quotes like (a''mbuli) and it works.
But, how can I handle a double quote for example, a"mbuli