SQLite Data Types: Complete Guide

2 years ago
William Carter
1 minute

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.

bannerAds