Storage Class in SQLite
A storage class can be called a collection of similar DataTypes. SQLite provides the following storage classes:
|
Storage Class |
Value Stored |
|---|---|
|
NULL |
NULL |
|
INTEGER |
Signed Integer (1, 2, 3, 4, 5, or 8 bytes depending on magnitude) |
|
REAL |
Floating point value (8 byte IEEE floating-point numbers) |
|
TEXT |
TEXT string (encoded in UTF-8, UTF-16BE or UTF-16LE |
|
BLOB (Binary Large Object) |
Data stored exactly the way it was input, generally in binary format |
The term Storage Class can be used mutually with DataType.
SQLite Datatypes and its Corresponding Python Types
SQLite is a C-language-based library that provides a portable and serverless SQL database engine. It has a file-based architecture; hence it reads and writes to a disk. Since SQLite is a zero-configuration database, no installation or setup is needed before its usage. Starting from Python 2.5.x, SQLite3 comes default with python.
In this article, we will discuss SQLite DataTypes and their corresponding Python Types
Contact Us