[sqlite] numeric string quotation

I have table: CREATE TABLE test ( alfa char(5) NOT NULL default '', ); when i .dump i obtain: INSERT INTO test VALUES(01000); but when i import in Mysql, i obtain test = '1000' and not test = '01000' because .dump create: INSERT INTO test VALUES(01000); and not: INSERT INTO test

[sqlite] numeric string quotation db2 to db3

I have sqlite2 table: CREATE TABLE test ( alfa char(5) NOT NULL default '', ); when i .dump i obtain: INSERT INTO test VALUES(01000); but when i import in sqlite3, i obtain test = '1000' and not test = '01000' because .dump create: INSERT INTO test VALUES(01000); and not: INSERT INTO test

Re: [sqlite] numeric string quotation db2 to db3

I undstand, but now i have to import a large db2 in db3. Richard Hipp ha scritto quanto segue il 31/05/2013 19.44 On Fri, May 31, 2013 at 1:32 PM, Spora sp...@email.it mailto:sp...@email.it wrote: I have sqlite2 table: In sqlite2, everything is a string. So there is no solution

Re: [sqlite] numeric string quotation db2 to db3

But i see that sqlMaestro is able to do it. How can he do? Richard Hipp ha scritto quanto segue il 31/05/2013 19.44 On Fri, May 31, 2013 at 1:32 PM, Spora sp...@email.it mailto:sp...@email.it wrote: I have sqlite2 table: In sqlite2, everything is a string. So there is no solution

Re: [sqlite] numeric string quotation db2 to db3

...@sqlite.org] On Behalf Of Spora Sent: Friday, May 31, 2013 1:01 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] numeric string quotation db2 to db3 But i see that sqlMaestro is able to do it. How can he do? -- Caselle da 1GB, trasmetti allegati fino a 3GB e in piu' IMAP, POP3 e SMTP

Re: [sqlite] numeric string quotation db2 to db3

it is too complicated for me Richard Hipp ha scritto quanto segue il 31/05/2013 20.29 On Fri, May 31, 2013 at 2:18 PM, Spora sp...@email.it mailto:sp...@email.it wrote: I need a scriptable solution. Probably if you modify this line of code: http://www.sqlite.org/src/artifact/46a1757c1

[sqlite] import with quotation mark

Last Sqlite is not able to import line as this: 01010aa16020b'bbcc, 33e fff31/03/13 Error: file.txt line 298: expected 9 columns of data but found 8 With previous version i not have this problem. Do it is possible to add a switch to ignore ''

Re: [sqlite] import with quotation mark

://www.sqlite.org/cvstrac/wiki?p=ImportingFiles *From:* Spora sp...@email.it *To:* sqlite-users@sqlite.org *Sent:* Wednesday, April 24, 2013 2:11 PM *Subject:* [sqlite] import with quotation mark Last Sqlite is not able to import line

[sqlite] import problem

I have problem when import with versione superior to 3071000. No problem with 3071000. ..\sqlite3 -echo aa_VUOTO.db 0aa.script .separator \t .import aa.txt aa Error: aa line 1744: expected 5 columns of data but found 2 .import aa aa Error: aa.txt line 82886: expected 9 columns of data but

[sqlite] import problem

I have problem when import with versione superior to 3071000. No problem with 3071000. ..\sqlite3 -echo aa_VUOTO.db 0aa.script .separator \t .import aa.txt aa Error: aa line 1744: expected 5 columns of data but found 2 .import aa aa Error: aa.txt line 82886: expected 9 columns of data but

Re: [sqlite] import problem

Donald Griggs ha scritto quanto segue il 16/05/2012 13.24 Hello, Spora, Regarding: *I have problem when import with versione superior to 3071000. No problem with 3071000.* ..\sqlite3 -echo aa_VUOTO.db 0aa.script .separator \t .import aa.txt aa Error: aa line 1744: expected 5 columns