Saturday, 24 August 2013

Escaping a INSERT query in sqlite

Escaping a INSERT query in sqlite

How would folloing query be escaped properly in SQLITE? I don't seem to be
able to find a working way to escape the fiel path at the end.
insert into mytable values ('IMG_1862_a.jpg', 'True', 'True', 'I:\where
i've been\stock laptop\IMG_1862_a.jpg')
i tried a lot including:
insert into mytable values ('IMG_1862_a.jpg', 'True', 'True',
'I:\where i^'ve been\stock laptop\IMG_1862_a.jpg') ESCAPE '^'

No comments:

Post a Comment