What is the difference between related SQLite data-types like INT, INTEGER, SMALLINT and TINYINT?

by

SQLite, technically, has no data types, there are storage classes in a manifest typing system, and yeah, it’s confusing if you’re used to traditional RDBMSes. Everything, internally, is stored as text. Data types are coerced/converted into various storage locations based on affinities (ala data types assigned to columns).

The best thing that I’d recommend you do is to :

  1. Temporarily forget everything you used to know about standalone database datatypes

  2. Read the above link from the SQLite site.

  3. Take the types based off of your old schema, and see what they’d map to in SQLite

  4. Migrate all the data to the SQLite database.

Note: The datatype limitations can be cumbersome, especially if you add time durations, or dates, or things of that nature in SQL. SQLite has very few built-in functions for that sort of thing. However, SQLite does provide an easy way for you to make your own built-in functions for adding time durations and things of that nature, through the sqlite3_create_function library function. You would use that facility in place of traditional stored procedures.

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. ALTER TABLE ADD COLUMN IF NOT EXISTS in SQLite
  18. Create table in SQLite only if it doesn’t exist already
  19. How do DATETIME values work in SQLite?
  20. Add ON DELETE CASCADE behavior to an sqlite3 table after it has been created
  21. Is there a boolean literal in SQLite?
  22. sqlite get ROWID
  23. svn cleanup: sqlite: database disk image is malformed
  24. Will SQLite performance degrade if the database size is greater than 2 gigabytes?
  25. Truncate a SQLite table if it exists?
  26. SQLite for large data sets?
  27. Integration Testing Entity Framework code first with in-memory database
  28. How to get the number of rows of the selected result from sqlite3?
  29. How to get the last index of a substring in SQLite?
  30. SQLITE3 VACUUM, “database or disk is full”

Leave a Comment