I have json column in my table. something like this: "{"en": "english name", "ka": "ქართული"}". when i query database, for kafield i get this: "{"en":"english name","ka":"\u10e2\u10d4\u10e1\u10e2\u10d8"}". how can i get data in foreign language in it's original form? . this worked fine with mysql.
I'm not sure, but I think that SQlite does not save real JSON column whereas MySQL does.
So you have to stringify you JSON data to save it to the SQLite database.
And when you retrieve your JSON stringified data from the database, you have to parse it to a JSON object.
Tell me if it helps ;).
Please or to participate in this conversation.