How to save a Json String in sqlite?

Question

I have an sqlite database. The column where I want to save my JsonString in, has the data type TEXT. Everytime I want to insert a dataset I get no error until I try to read it out again, then I get an error that my curser may be at the wrong place. But when instead of a json give a usual string everything works fine. Since I don't really now what symbols might be in my json, is there at all a way to put a json into an sqlite database? (It is a large json so I can't really insert every value of it seperatly).

How can I save a JsonString else so that I can get I even if my application is closed?

I know I could put it in al file but since a database has a better structure and basiccly is a file too I would prefer to find a way working with the database.

@Blackbelt it is a json in a string so I can´t really do that — J.Doe, Oct 16 '15 at 10:55
*t it is a json in a string*, then it is already a string. Save it as string — Blackbelt, Oct 16 '15 at 10:57
refer this http://stackoverflow.com/questions/16603621/how-to-store-json-object-in-sqlite-database — , Oct 16 '15 at 11:00
it sounds like your having issues loading it from the db correct? Are you pulling it via `json = getString(int column)` and then using `new JSONObject(json)` to convert? — RobVoisey, Oct 16 '15 at 11:07
@RobVoisey I am not getting to new JSONObject(json) because when I get the string I get a null Pointer exeption — J.Doe, Oct 16 '15 at 11:11
in that case there is something wrong with the query, post the code showing how you load it. — RobVoisey, Oct 16 '15 at 11:37
@RobVoisey the problem isn´t the loading. As I said when I use a normal sitring instead of the jsonString it works fine — J.Doe, Oct 16 '15 at 12:20

Andrei T · Answer 1 · 2015-10-16T12:06:01.910

1

Save as a string:

json.toString();

Although I would parse it, it is faster this way.

edited Oct 16 '15 at 12:06

answered Oct 16 '15 at 10:54

Andrei T

2,757
3
19
28

How to save a Json String in sqlite?

1 Answers1