I think you showed us the insert you do and not the .dump result. You need to ensure your inserted values are single-quoted.
sqlite> create table test(alfa char(5) not null default ''); sqlite> insert into test values(01000); sqlite> .dump PRAGMA foreign_keys=OFF; BEGIN TRANSACTION; CREATE TABLE seqnumber(stepid); INSERT INTO "seqnumber" VALUES(5); CREATE TABLE test(alfa char(5) not null default ''); INSERT INTO "test" VALUES('1000'); COMMIT; sqlite> insert into test values('01000'); sqlite> .dump PRAGMA foreign_keys=OFF; BEGIN TRANSACTION; CREATE TABLE seqnumber(stepid); INSERT INTO "seqnumber" VALUES(5); CREATE TABLE test(alfa char(5) not null default ''); INSERT INTO "test" VALUES('1000'); INSERT INTO "test" VALUES('01000'); COMMIT; -----Original Message----- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Spora Sent: Friday, May 31, 2013 11:52 AM To: sqlite-users@sqlite.org Subject: [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 VALUES('01000'); how to solve? -- 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 l'arte e vuoi arredare casa con stile? Su MisterCupido.com puoi acquistare le RIPRODUZIONI DEI QUADRI di: Van Gogh, Monet, Klimt, Modigliani, Cezanne, Hayez, Michelangelo, Raffaello, ecc Clicca qui: http://adv.email.it/cgi-bin/foclick.cgi?mid=12386&d=31-5 _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users