SQLite: 2.8.13 OS: HP-UX B.11.11 Hi,
char and varchar fields containing digits only are dumped without qoutes: sqlite> create table my_table(id integer primary key, A varchar(25), B char(25)); sqlite> insert into my_table values(NULL, '1234567890','1234567890'); sqlite> insert into my_table values(NULL, ' 12345', '12345x'); $ sqlite dbfile.sqlite ".dump" > dbfile_dump.sql File dbfile.sql: create table my_table(id integer primary key, A varchar(25), B char(25)); INSERT INTO my_table VALUES(1,1234567890,1234567890); INSERT INTO my_table VALUES(2,' 12345','12345x'); I understand this is due to SQLite typelessness. Is it, by any chance, possible to change this (char, varchar, text, etc. 'text' fields dumped always with quotes) ? Or would it be violation of principle ? Sometimes I need to use SQLite-generated scripts to load other databases, which are type-sensitive and it would really help. Regards, Jarek Jaroslaw Nozderko GSM +48 601131870 / Kapsch (22) 6075013 [EMAIL PROTECTED] IT/CCBS/RS - Analyst Programmer --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
