> On Oct 17, 2016, at 2:12 AM, Quan Yong Zhai <q...@msn.com> wrote:
> Or after prepare “ INSERT INTO test VALUES(?) “
>   Bind_text      “62.027393”
>   Bind_double  62.027393
> In all the four situation,  the  value insert into foo field  is binary 
> identical, it’s a 8-bytes REAL value.

I suspect the OP generated that number through computation, and it’s not 
exactly equal to a double parsed from the string “62.027393”. In other words, 
the OP ended up with a number n, such that
        string(n) = “62.027393”  (using some particular format like “%.6f”)
        n != parse(“62.027393”)

The original code must be doing Bind_double(n); whereas in your code the parser 
had to read the string “62.027393” at parse time and generate a double from it, 
which is not equal to n.

sqlite-users mailing list

Reply via email to