On Fri, May 31, 2013 at 1:32 PM, Spora <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
> 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
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
