Inserting string to SQLite using Android

Question

How do we insert strings that have commas (,) in them into SQLite database using Android ?

If there are no commas within the values to be inserted, then insertion happens fine. Say for example see the Android code:-

db.execSQL("insert into Student ( id, name, mark ) values (1, 'Geevarghese', 100)");

Inserting into the db works well.

If I modify my question to add the address to the database, like the following,

db.execSQL("insert into Student ( id, name, mark, address ) values (1, 'Geevarghese', 100, 'No.20, Cochin, Kerala')");

This query doesn't insert data into the database

How to properly insert data that includes comma into SQLite db from Android ?

use scape sequence \ for each special character that you want as string to be inserted in db — Rustam
– Rustam, Commented Sep 20, 2014 at 6:15

Vivek Mishra · Accepted Answer · 2014-09-20 07:20:22Z

3

You can use ContentValues as follow:

ContentValues initialValues = new ContentValues();

initialValues.put("id", 1);
initialValues.put("name", "Geevarghese");
initialValues.put("mark", 100);
initialValues.put("address", "No.20, Cochin, Kerala");

db.insert("Student", null, initialValues);

Ref:http://developer.android.com/reference/android/content/ContentValues.html

Hope It helps :)

answered Sep 20, 2014 at 7:20

Vivek Mishra

3522 silver badges12 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Digvesh Patel · Accepted Answer · 2014-09-20 06:14:26Z

0

String data = "No.20, Cochin, Kerala";
data = data.replaceAll("," , "\,");


db.execSQL("insert into Student ( id, name, mark, address ) values (1, 'Geevarghese', 100, '"+data+"')");

answered Sep 20, 2014 at 6:14

Digvesh Patel

6,5331 gold badge23 silver badges34 bronze badges

Collectives™ on Stack Overflow

Inserting string to SQLite using Android

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related