On Jul 13, 2009, at 3:38 PM, Wilfried Mestdagh wrote: > Hi, > > It seems that if I create the table as a field type 'char' instead of > 'string' then the issue is solved. But I thought the field type was > of non > importance?
Details here: http://www.sqlite.org/datatype3.html#affinity > > > rgds, Wilfried > > 2009/7/13 Wilfried Mestdagh <wmestd...@gmail.com> > >> Hello, >> >> I'm using sqlite3.dll and Delphi 7. In certain cirumstances a >> string seems >> to be converted to a number. To test I use SQLiteSpy from Ralf >> Junker wich >> is a nice tool. >> >> When I do this: >> insert into Queue (NetworkID) values ("200907130833123740007") >> >> Then the result of the field NetworkID is: >> 2.00907130833124E20 >> >> To solve this I add a blank in front of the ID, like this: >> insert into Queue (NetworkID) values (" 200907130833123740007") >> >> But is this a good method, and is this a known issue? >> >> The table is created like this: >> 'create table Queue (' + >> '[NetworkID] string, ' + >> '[State] integer, ' + >> // Etc... >> >> -- >> mvg, Wilfried >> http://www.mestdagh.biz >> > > > > -- > mvg, Wilfried > http://www.mestdagh.biz > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
