Escape special characters in sqlite

Question

I am trying to update a SQLite table in my Android application. Predicate for this update is built around a column which stores different resource URLs.

These URLs might contain special characters such as /~?=; (and even &).

My query looks like:

update TableName where columnVal = '/some/fake/~/id?u=0&amp;rl=url';

The update query doesnt work; it does not identify the column satifying the condition.

How can I escape these characters?

Please advise.

score 5 · Accepted Answer · answered Nov 09 '10 at 11:25

5

You should be using the method update instead of generating the SQL yourself. The built-in methods will do all the needed escaping for you.

http://developer.android.com/reference/android/database/sqlite/SQLiteDatabase.html

answered Nov 09 '10 at 11:25

RoToRa

37,635
12
69
105

3

I don't mean to be a douchebag, but this is not really an answer to the OP's question, though, is it? :) – Lukas1 Feb 11 '14 at 09:56

score 2 · Answer 2 · edited May 23 '17 at 12:04

2

Answered here: Android quotes within an sql query string

edited May 23 '17 at 12:04

Community

1
1

answered Nov 09 '10 at 11:20

Fredrik Leijon

2,792
18
20

this only escapes quotes and doublequotes, no? doesn't handle any other special characters – Lukas1 Feb 11 '14 at 10:25

Escape special characters in sqlite

2 Answers2

Linked