Re: [sqlite] How to input a double num?

[Dan Bishop]

liubin liu wrote:
> Now I use the sqlite3_mprintf() and the "%f" to get the double num. My code
> is below.
>
> Now there is a num like "212345678901234567890123456.988290112". With the
> way of "sqlite3_mprintf()" and "%f", the num is cut to
> "212345678901234600000000000.000000".
>
>
> How to input the num "212345678901234567890123456.988290112"?
You can't.  A double only has 53 bits (about 16 decimal digits) of 
precision.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users