On Sep 14, 2005, at 9:51 AM, Nemanja Corlija wrote:
2) While creating tables, I've been specifying the data type after
the
field name:
create table test(field_1 integer, field_2 text);
The only advantage of this is that the database could possible store
the
data in a more compact form, correct? If that's not a concern,
leaving it
all as text would not make a difference?
Data type affinity is used at runtime too (comparison for example).
See http://www.sqlite.org/datatype3.html for more details.
and, providing all the detailed cols info during table creation time
would be helpful if at some point in the future you decided to move
from SQLite to some other db...
--
Puneet Kishor
