Hi Dan, Thank you for your reply. I read:
> Under circumstances described below, the database engine may convert > values between numeric storage classes (INTEGER > and REAL) and >TEXT during query execution But the circumstances are not really described (possible I cannot read between the lines as my English is not perfect). So as far as I understand the page if I want to store / retrieve a string (which can be a numeric string) I have to create my field as "char", "text" or as "none". Is this correct? thanks, Wilfried 2009/7/13 Dan <[email protected]> > > 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 <[email protected]> > > > >> 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 > > [email protected] > > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- mvg, Wilfried http://www.mestdagh.biz _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
