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