SQLite Sütun Tipleri

Giriş
Açıklaması şöyle. Numeric tipi, Integer ve Real'in atası gibi düşünülebilir.

SQLite, unlike most other RDBMS, uses a dynamic type system. This means that any of SQLite's fives storage classes can be present in any column, despite that the column belongs to one type. But obviously, it is not best practice to mix types within a single column. For example, mixing numeric and character data in the same column is bad practice, as it would be in any database. The five actual storage classes in SQLite are:

NONE/NULL -
INTEGER
REAL
TEXT
NUMERIC

Affinity
Açıklaması şöyle.

SQLite introduced a concept known as type "affinities." They were introduced in order to maximize compatibility between SQLite and other databases. 

Sütun tipi farklı farklıymış gibi görünse de aslında altta temel tiplerden birisini kullanıyor.

Integer Affinity
Açıklaması şöyle.

Numbers without a decimal component would be assigned to the INTEGER storage class.

Şu tipler olabilir.
INT
INTEGER
TINYINT
SMALLINT
MEDIUMINT
BIGINT
UNSIGNED BIG INT
INT2
INT8

Null Affinity
Şu tipler olabilir.
BLOB
no datatype specified

Numeric Affinity
Şu tipler olabilir.
NUMERIC
DECIMAL(10,5)
BOOLEAN
DATE
DATETIME

Real Affinity
Açıklaması şöyle.

The REAL storage class is used for numeric data with a decimal component.

Şu tipler olabilir.
REAL
DOUBLE
DOUBLE PRECISION
FLOAT

Text Affinity
Şu tipler olabilir.
CHARACTER(20)
VARCHAR(255)
VARYING CHARACTER(255)
NCHAR(55)
NATIVE CHARACTER(70)
NVARCHAR(100)
TEXT
CLOB