On 10 Sep 2010, at 6:01pm, Andrew Wood wrote: > One related question. The library Im using maps numeric types to one of > the following C types: > > unsigned long int > signed long int > unsigned int (short) > signed int (short) > float > double > > How does SQLite distinguish between ordinary floats and doubles, and > between long & short ints, and signed or unsigned ints?
It doesn't. Why should it ? As you can see from the two pages <http://www.sqlite.org/c3ref/bind_blob.html> <http://www.sqlite.org/c3ref/column_blob.html> numbers can be bound and retrieved as 'int' or 'double'. Conversion from those is probably down to whatever compiler you choose to use: most compilers provide some form of toll-free conversion from one numeric format to another. And entirely down to however you want your application to handle numeric values internally. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users