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 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. _________________________________________________ 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: Ami i PELUCHE? Acquistali online su MisterCupido.com! Tante offerte su: Disney, Simpson, Spongebob, Puffi, Sette Nani, Super Mario, Barbapapà, Teletubbies, Angry Birds, ecc Clicca qui: http://adv.email.it/cgi-bin/foclick.cgi?mid=12384&d=31-5 _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
