On 3/22/2011 9:53 AM, LacaK wrote: > Base idea is store as TEXT when : > 1. column value is supplied as TEXT (only in case sqlite3_bind_text) > 2. conversion to REAL or INTEGER leads to loose of precision (digits) > > I do not know details how to implement it ;-) > May be, 1. strip out leading and trailing spaces and zeroes 2. and then > analyze string if contains only digits and decimal separator
Which of the following should be left as text: '1e+003' '10e2' '1000' '+.01e05' -- Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
