Equals sign in url not working

Question

i got a problem which i tried hard to solve with searching with google because will be a simple solution.

I want to open the following url:

http://<<IP>>/query.html?sql="select * from ADAnreden"

To do this, i write this url in a string to open it with HttpGet...

String url = "http://"+ip+"/query.html?sql=\"select * from ADAnreden\"";

So i escaped the " infront of select and after ADAnreden. But the problem is that the following error is comming up:

Illegal character in query at index 36.

This is the equals sign. So how can i escape the = ? The backslash is not working.

Thanks for help

I think wrapping this part in a url encoder should help `\"select * from ADAnreden\"` — Armand, Sep 10 '13 at 08:05

score 3 · Accepted Answer · edited May 23 '17 at 10:27

3

The issue is the escaping for the URL, not for Java. Spaces are not valid in URLs. See this answer for more about URL encoding in Android.

edited May 23 '17 at 10:27

Community

answered Sep 10 '13 at 08:09

isaach1000

score 2 · Answer 2 · answered Sep 10 '13 at 08:12

2

you must encode the query before using it as URL, see URLEncoder.encode(query);

answered Sep 10 '13 at 08:12

Mohammad Ersan

2 Answers2