Consider the following SQL Statement:

 

create table foo(val1 integer, val2 integer, val3 integer);

insert into foo values('1', '2', '3');

 

When I call sqlite3_column_int(stmt, columnNum), must it convert the
string to integer each time or will it perform that conversion on
insertion?

Is it faster at retrieving the values as integers if I insert them as
integers instead of strings?

 

-Shaun

_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to