>
>
> Ok, I can see this. But I cannot forsee the real implications
> though. If I
> have a statement like
>
> create table mytable(pnumber integer, name varchar(20), primary
> key(pnumber))
>
> what are the reported datatypes? still integer and varchar(20)?
Yes. But if you do
CREATE TABLE t2 AS SELECT * FROM mytable;
Then the reported datatypes for t2 will be INT and TEXT.
D. Richard Hipp
d...@hwaci.com
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
