And...no conversion is performed if you declare the field as text and insert as text.
Yes, but I can not affect column type ... FreePascal SQLite3 connector must be able to work with any user database. And when user defines column like NUMERIC or DECIMAL ... so with NUMERIC column affinity, then it does not help when I write/bind numbers like TEXT (sqlite3_bind_text) '123456789123456789.123456789' because SQLite ALWAYS convert such "text number" to native floating-point or integer number, which leads to lost of precision. So probably before bind I will test if number of significant digits > 15 then I will use sqlite3_bind_blob else sqlite3_bind_double -Laco.
_______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
