Thomas Lenders wrote: > I tried creating the field as INTEGER, but 10 digit numbers where > imported as 0.
SQLite uses 64-bit integers, for about 19 decimal digits. The problem must be with the software that populates the table. > I assume the field was created as 32 bit integer and invalid entries got > a default value. SQLite doesn't distinguish between 32-bit and 64-bit integers. There's nothing special you have to put into CREATE TABLE statement to enable 64-bit integers - they just work. > I also tried LONGINT, BIGINT and INT64 but no joy. What would be the > correct syntax for > longer ints ? Like I said, no special syntax is needed. Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users