2009/7/17 Atul_Vaidya <atul.vai...@prototechsolutions.com>: > > Hi, . . . > My question is, is it possible in > SQlite to retrieve the data stored in the database in the format in which it > is stored when the data was inserted in it ? for eg: if I store the data as > an Int, will I get it back as an Int, from what i get from the get_table > function is a char**.If yes, > then will this enhance the speed of querying and how to achieve this,without > using sqlite3_get_table ? > Regards, > Atul. >
http://www.sqlite.org/cintro.html will help. Also see http://www.sqlite.org/cvstrac/wiki?p=SimpleCode for example of use. Speed should be better, since some type conversions are avoided; but type conversions are a minimal time cost compared to that of disk reads. Rgds, Simon _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users