fab wrote:
Hi!
I have a field declared as:
tel varchar(20) NOT NULL default '',
which owns a serial number, under 2.8.14 I get the same I entered in the
database but with the last 3.x it removes the heading '0' if there is
one.
Works for me:
[EMAIL PROTECTED] bld]$ ./sqlite3 test.db
SQLite version 3.0.2
Enter ".help" for instructions
sqlite> create table t1(tel varchar(20) not null default '');
sqlite> insert into t1 values('0001234');
sqlite> select * from t1;
0001234
Perhaps you could be more specific about your problem. You should
also post this to the mailing list.
--
D. Richard Hipp -- [EMAIL PROTECTED] -- 704.948.4565
