Hi, I have a tricky situation where I have strings in my data that have both single and double quotes. I am using the C APIs of sqlite3_prepare and sqlite3_exec to insert data into the database. How do I prepare the query string in such case where the string data have both single and double quotes.
FYI, The string data are some meta data information and hence they can contain all possible characters with any possible combination and there is not restriction for special characters. Your suggestions are highly appreciated. Thank you, With regards, Sankara Narayanan B.