Double quotes in the query

Question

Hello. There is a query like:

Insert into baza Values(str);

If the str contains the character "(double quote) - a syntax error takes off. How is it better to bypass such a thing? I am writing to java.

Drac5 Drac5 2,611 7 silver marks 15 bronze marks · Accepted Answer · 2013-02-24T11:20:24

Use parameterized queries:

 SQLiteCommand cmd = new SQLiteCommand(@"Insert into baza Values(@param)", SQLConnection); cmd.Parameters.Add(new SQLiteParameter("@param")); cmd.Parameters["@param"].Value = str;

Double quotes in the query

1 answer 1

More articles: