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 to your problem there. Please consider using sqlite3 instead. SQLite3 came out in 2004. The last release of sqlite2 was in 2005. The last update to the sqlite2 sources was in 2007. 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 VALUES('01000'); how to solve? excuse previuos in MySql. -- Caselle da 1GB, trasmetti allegati fino a 3GB e in piu' IMAP, POP3 e SMTP autenticato? GRATIS solo con Email.it http://www.email.it/f Sponsor: Clicca qui: http://adv.email.it/cgi-bin/__foclick.cgi?mid=12824&d=31-5 <http://adv.email.it/cgi-bin/foclick.cgi?mid=12824&d=31-5> _________________________________________________ sqlite-users mailing list sqlite-users@sqlite.org <mailto:sqlite-users@sqlite.org> http://sqlite.org:8080/cgi-__bin/mailman/listinfo/sqlite-__users <http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users> -- D. Richard Hipp d...@sqlite.org <mailto:d...@sqlite.org>
-- Caselle da 1GB, trasmetti allegati fino a 3GB e in piu' IMAP, POP3 e SMTP autenticato? GRATIS solo con Email.it http://www.email.it/f Sponsor: Crea la tua PEC con sconti fino al 20%: 2GB di spazio, sms di notifica, archivio di sicurezza. * Prova adesso! Clicca qui: http://adv.email.it/cgi-bin/foclick.cgi?mid=12826&d=31-5 _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
