How to insert/bind a float datatype value in a sqlite3 database

Question

I was able to insert and retrieve integer, text datatype in my sqlite3 database. Can you please guide me how to do the same for a float datatype for my iPhone app.

I would suggest you to either quote your answer here or remove the question to prevent unanswered questions on SO. — Till, Nov 22 '11 at 21:32
sqlite3_bind_double(stmt, 7, [[person valueForKey:@"salary"] floatValue]); — user1048396, Nov 22 '11 at 21:40
I am adding it in comment as I am not able to answer my own question — user1048396, Nov 22 '11 at 21:41

score 1 · Answer 1 · edited May 23 '17 at 12:12

1

sqlite3_bind_double(stmt, 7, [[person valueForKey:@"salary"] floatValue]);

http://www.sqlite.org/c3ref/bind_blob.html

Difference between float and double

edited May 23 '17 at 12:12

Community

1
1

answered May 04 '13 at 13:59

hol

8,255
5
33
59

How to insert/bind a float datatype value in a sqlite3 database

1 Answers1