Re: [sqlite] string is converted into a number

On 14 Jul 2009, at 12:49am, John Machin wrote: > On 14/07/2009 3:04 AM, Simon Slavin wrote: >> >> The reference you were pointed to explains what happens: >> >> http://www.sqlite.org/datatype3.html#affinity >> >> So you want 'TEXT' ... 'char' doesn't mean anything to SQLite. > > @Simon: I'm not

Re: [sqlite] string is converted into a number

On 14/07/2009 3:04 AM, Simon Slavin wrote: > On 13 Jul 2009, at 4:35pm, Wilfried Mestdagh wrote: > >> 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

Re: [sqlite] string is converted into a number

On 13 Jul 2009, at 4:35pm, Wilfried Mestdagh wrote: > 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

Re: [sqlite] string is converted into a number

Wilfried Mestdagh wrote: > 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

Re: [sqlite] string is converted into a number

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

Re: [sqlite] string is converted into a number

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

Re: [sqlite] string is converted into a number

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? rgds, Wilfried 2009/7/13 Wilfried Mestdagh > Hello, > > I'm using sqlite3.dll and Delphi 7. In certain

[sqlite] string is converted into a number

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: