Re: [sqlite] System.Data.Sqlite, not using parameterized query, how to encode special characters

On 16 Jan 2015, at 7:06pm, Andy (KU7T) wrote: > If I just build the sql string myself, how can I solve encoding > issues as mentioned above? There's only one character which should cause a problem with embedded strings: the apostrophe. And you escape this by doubling it.

[sqlite] System.Data.Sqlite, not using parameterized query, how to encode special characters

Hi, Some of my single row inserts use parameterized queries today to make encoding easier. For example having embedded single quotes in strings etc. Now, I would like to take advantage of the multi row inserts as described in