SQLite Data Types (Magic xpa 3.x)
The table below shows the results of a Magic xpa Get Definition operation from an SQLite table, with Magic xpa equivalents for SQLite data types.
|
SQLite Data Type
|
Magic xpa Data Type
|
|
INTEGER
|
Numeric N9
|
|
TINYINT
|
Numeric 3
|
|
SMALLINT
|
Numeric N5
|
|
BIGINT
|
Numeric N9
|
|
CHAR(x)
|
Alpha x
|
|
VARCHAR(x)
|
Alpha x
|
|
NCHAR(x)
|
Unicode x
|
|
NVARCHAR(x)
|
Unicode x
|
|
TEXT
|
Blob (Unicode)
|
|
CLOB
|
Blob (Ansi)
|
|
BLOB
|
Blob (Binary)
|
|
REAL
|
Numeric 10.3 (as in DBMS)
|
|
DOUBLE PRECISION
|
Numeric 10.3 (as in DBMS)
|
|
FLOAT
|
Numeric 10.3 (as in DBMS)
|
|
NUMERIC
|
Numeric 10.3 (as in DBMS)
|
|
DECIMAL (x,y)
|
Numeric (x-y,y)
|
|
BOOLEAN
|
Logical
|
|
DATE
|
Date
|
|
DATETIME
|
Date & Time
|
