LacaK <la...@users.sourceforge.net> wrote: >> Problem will be solved if SQLite will store such values as text ... so >> will behave like this: >> 1. is supplied value in TEXT (sqlite3_bind_text) >> 2. if yes then try convert this text value into INTEGER or REAL >> 3. convert back to text and compare with original value >> 4. if equal then store it as INTEGER or REAL, if not then store it as is >> as supplied in (1).
Does this mean that, say, '042' or '42.00' are stored as text? Do you think that would be desirable? -- Igor Tandetnik
_______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users