On 30 Sep 2009, at 10:02pm, Tjalve wrote: > I got a strange problem with SQLite 3.0. > > I cannot seem to save integers that starts with zero correctly. > > eks. 080168 gets saved as 80168, but if i try only 0, its saved as 0. > I have tried to make a new table with a only a INT field to test but i > get the same result.
Define the column as TEXT (which you have probably done). Put single quotes around the value you're writing: '080168'. In SQLite all strings must be quoted. > Using SQLite Admin and SQLite Manager (firefox addon). Depending on exactly how you're using them, if they don't handle this properly it's possible they're buggy. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
