Hello! On Thursday 25 February 2010 02:53:32 Igor Tandetnik wrote: > http://www.sqlite.org/datatype3.html > For conversions between TEXT and REAL storage classes, SQLite considers the > conversion to be lossless and reversible if the first 15 significant decimal > digits of the number are preserved.
The SQLite datatyping is very different from other RDBMS: sqlite> select 1='1'; 0 Postgres: template1=# select 1='1'; ?column? ---------- t And there are a lot of problem as result, see some tests here: http://sqlite.mobigroup.ru/src/wiki?name=tclsqlite I don't know how to fix it in the SQLite core. My patch for the tclslite interface can't resolve the internal problem... Best regards, Alexey Pechnikov. http://pechnikov.tel/ _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
