What is the difference between SQLite integer data types like int, integer, bigint, etc.?

by

From the SQLite3 documentation:

http://www.sqlite.org/datatype3.html

Most SQL database engines (every SQL database engine other than
SQLite, as far as we know) uses static, rigid typing. With static
typing, the datatype of a value is determined by its container – the
particular column in which the value is stored.

SQLite uses a more general dynamic type system. In SQLite, the
datatype of a value is associated with the value itself, not with its
container. The dynamic type system of SQLite is backwards compatible
with the more common static type systems of other database engines in
the sense that SQL statement that work on statically typed databases
should work the same way in SQLite. However, the dynamic typing in
SQLite allows it to do things which are not possible in traditional
rigidly typed databases.

So in MS Sql Server (for example), an “int” == “integer” == 4 bytes/32 bits.

In contrast, a SqlLite “integer” can hold whatever you put into it: from a 1-byte char to an 8-byte long long.

The above link lists all types, and gives more details about Sqlite “affinity”.

The C/C++ interface you’re referring to must work with strongly typed languages.

So there are two APIs: sqlite3_column_int(), max 4-byte; and sqlite3_column_int64()

http://www.sqlite.org/capi3ref.html#sqlite3_int64

More Related Contents:

  1. near “varchar”: syntax error [closed]
  2. How do I make an UPDATE while joining tables on SQLite?
  3. How do I rename a column in a SQLite database table?
  4. How do I check in SQLite whether a table exists?
  5. How to set Sqlite3 to be case insensitive when string comparing?
  6. Escape single quote character for use in an SQLite query
  7. Difference between 2 dates in SQLite
  8. Update with Join in SQLite
  9. Can I read and write to a SQLite database concurrently from multiple connections?
  10. How do I store and retrieve a blob from sqlite?
  11. SQLite error ‘attempt to write a readonly database’ during insert?
  12. Store boolean value in SQLite
  13. Can SQLite support multiple users?
  14. SQLite add Primary Key
  15. Encrypted cookies in Chrome
  16. How delete table inner join with other table in Sqlite?
  17. Export from sqlite to csv using shell script
  18. ALTER TABLE ADD COLUMN IF NOT EXISTS in SQLite
  19. SQLite: How do I save the result of a query as a CSV file?
  20. Create table in SQLite only if it doesn’t exist already
  21. How do DATETIME values work in SQLite?
  22. Add ON DELETE CASCADE behavior to an sqlite3 table after it has been created
  23. Is there a boolean literal in SQLite?
  24. sqlite get ROWID
  25. Will SQLite performance degrade if the database size is greater than 2 gigabytes?
  26. SQLite for large data sets?
  27. sql query – how to apply limit within group by
  28. SQLite database supporting Unicode data
  29. Creating stored procedure in SQLite
  30. SQLITE3 VACUUM, “database or disk is full”

Leave a Comment