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

Reply via email to