Salesforce

SQLite Data Types (Magic xpa 4.x)

« Go Back

Information

 
Created BySalesforce Service User
Approval Process StatusPublished
Objective
Description

SQLite Data Types (Magic xpa 4.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

Reference
Attachment 
Attachment