关于SQLite，存储中文数据总是报错

Question

存英文就没事，字符串类型英文也报错

db.execSQL("create table gwsp(sp_id NONE,sp_name NONE,sp_changdi NONE,sp_gold NONE,sp_num NONE)");

db.execSQL("INSERT INTO  gwsp(sp_id,sp_gold,sp_changdi,sp_name,sp_num)VALUES("+
       1+","+"6"+","+"qwewe"+","+6+","+8+");");

报错E/SQLiteLog: (1) no such column: qwewe

Answer 1

sql语句中字符串需要用单引号。

db.execSQL("INSERT INTO  gwsp(sp_id,sp_gold,sp_changdi,sp_name,sp_num)VALUES("+1+","+"6"+","+"'qwewe'"+","+6+","+8+");");

 

另:

操作数据库，最好使用orm的框架。

https://ormlite.com/