If what you want is a way to store floating point numbers with a precision other than double (8 bytes) to decrease space usage or to get more precisione the answer is no. The only native data types for sqlite are integer (which can simulate bools), string, double and blob. Plus of course NULL... See http://www.sqlite.org/datatype3.html Il giorno 06/mag/2013 05:05, "Igor Tandetnik" <i...@tandetnik.org> ha scritto:
> On 5/5/2013 8:24 PM, Igor Korot wrote: > >> Is there a way to select a precision either on the call to >> sqlite3_bind_double() or before it? >> > > What do you mean, select precision? The double value you pass to > sqlite3_bind_double() will be used as is. Are you saying you want to round > it first? Then go ahead and do that - I'm not sure what that has to do with > SQLite. > -- > Igor Tandetnik > > ______________________________**_________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-**bin/mailman/listinfo/sqlite-**users<http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users> > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users