What data types does SQLite support?

SQLite supports the following data types:

  1. INTEGER: A numerical type that can store any whole number value.
  2. Real: a data type that can store floating-point values.
  3. TEXT: A data type that can store string values.
  4. BLOB: Binary Large Object type, capable of storing any binary data.
  5. NULL is a data type that can store empty values.

Furthermore, SQLite also supports setting constraints and default values using keywords such as PRIMARY KEY, NOT NULL, UNIQUE, and DEFAULT.

广告
Closing in 10 seconds
bannerAds