Extracting Numeric value from SQLite

Question

My SQLite field is a numeric type (int). When i try to extract it into my application like this:

int id_quiz= (NSInteger) sqlite3_column_text(statement, 0);

i got a huge value like 129600224 which is not the correct one (and it changes every time i run the app).

However, in the same table, i got string value from other fields just fine:

NSString *question = [[NSString alloc] 
                                          initWithUTF8String:
                                          (const char *) sqlite3_column_text(
                                                                             statement, 1)];

The question is, how can i get a numeric value from SQLite? Thanx in advance.

Hector · Accepted Answer · 2012-03-14 09:55:03Z

3

Try this:

int id_quiz =sqlite3_column_int(statement, 0);

for more information SQLite

edited Mar 14, 2012 at 9:55

answered Mar 14, 2012 at 8:54

Hector

3,6512 gold badges32 silver badges48 bronze badges

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

Comments

trojanfoe · Accepted Answer · 2012-03-14 08:55:48Z

2

You need to fetch the column as an int, not as "text":

int id_quiz = sqlite3_column_int(statement, 0);

answered Mar 14, 2012 at 8:55

trojanfoe

123k23 gold badges219 silver badges249 bronze badges

Collectives™ on Stack Overflow

Extracting Numeric value from SQLite

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