Search code examples
androidsqlitecsvarabicfarsi

sqlite database in persian language

I tried to create a sqlite database from a csv file. I did it as it is said in this page : using your own sqlite db in android and this : import csv to sqlite

but the problem is when the table contains data in farsi/arabic language. sqlite shows that character as "_". what should I do?

PS. I want to use this DB in an android project.

edit: I import csv to sqlite using this code:

CREATE TABLE "android_metadata"("locale" TEXT DEFAULT 'en_US');
CREATE TABLE "addresses"(_id integer PRIMARY KEY,
nametext, meaning text);
.separator ","
.import test.csv mydb
Solution

  • sqlite supports UTF-8, UTF-16 and this is quite enough to store arabic or persian.

    Most probably you get "_" because the import tool expects different charset than the charset of your original file.