SQL types mapping: SQLite

Table 1. SQL data types mapping for SQLite
Original data types	SQLite data types
`CHAR(n)`	`CHAR(n) COLLATE RTRIM`
`VARCHAR(n[,m])`	`VARCHAR(n) COLLATE RTRIM`
`LVARCHAR(n)`	`VARCHAR(n) COLLATE RTRIM`
`NCHAR(n)`	`NCHAR(n)`
`NVARCHAR(n)`	`NVARCHAR(n)`
`BOOLEAN`	`BOOLEAN`
`SMALLINT`	`SMALLINT`
`INTEGER`	`INTEGER`
`BIGINT`	`BIGINT`
`INT8`	`BIGINT`
`SERIAL[(start)]`	`INTEGER` (see note 1)
`BIGSERIAL[(start)]`	N/A (see note 1)
`INT8[(start)]`	N/A (see note 1)
`DOUBLE PRECISION / FLOAT[(n)]`	`FLOAT`
`REAL / SMALLFLOAT`	`SMALLFLOAT`
`DECIMAL(p,s)`	`DECIMAL(p,s)`
`DECIMAL(p)`	`DECIMAL(p)`
`DECIMAL`	`DECIMAL`
`MONEY(p,s)`	`DECIMAL(p,s)`
`MONEY(p)`	`DECIMAL(p,2)`
`MONEY`	`DECIMAL(16,2)`
`TEXT`	`TEXT`
`BYTE`	`BLOB`
`DATE`	`DATE`
`DATETIME HOUR TO HOUR`	`SMALLTIME`
`DATETIME HOUR TO MINUTE`	`SMALLTIME`
`DATETIME HOUR TO SECOND`	`TIME`
`DATETIME HOUR TO FRACTION(n)`	`TIME(n)`
`DATETIME MINUTE TO MINUTE`	`SMALLTIME`
`DATETIME MINUTE TO SECOND`	`TIME`
`DATETIME MINUTE TO FRACTION(n)`	`TIME(n)`
`DATETIME SECOND TO SECOND`	`TIME`
`DATETIME SECOND TO FRACTION(n)`	`TIME(n)`
`DATETIME FRACTION TO FRACTION(n)`	`TIME(n)`
`DATETIME YEAR TO YEAR`	`TINYDATETIME`
`DATETIME YEAR TO MONTH`	`TINYDATETIME`
`DATETIME YEAR TO DAY`	`TINYDATETIME`
`DATETIME YEAR TO HOUR`	`SMALLDATETIME`
`DATETIME YEAR TO MINUTE`	`SMALLDATETIME`
`DATETIME YEAR TO SECOND`	`DATETIME`
`DATETIME YEAR TO FRACTION(n)`	`DATETIME(n)`
`DATETIME MONTH TO MONTH`	`TINYDATETIME`
`DATETIME MONTH TO DAY`	`TINYDATETIME`
`DATETIME MONTH TO HOUR`	`SMALLDATETIME`
`DATETIME MONTH TO MINUTE`	`SMALLDATETIME`
`DATETIME MONTH TO SECOND`	`DATETIME`
`DATETIME MONTH TO FRACTION(n)`	`DATETIME(n)`
`DATETIME DAY TO DAY`	`TINYDATETIME`
`DATETIME DAY TO HOUR`	`SMALLDATETIME`
`DATETIME DAY TO MINUTE`	`SMALLDATETIME`
`DATETIME DAY TO SECOND`	`DATETIME`
`DATETIME DAY TO FRACTION(n)`	`DATETIME(n)`
`INTERVAL q1 TO q2`	`CHAR(50)`

Notes:

For serial emulation, see SERIAL and BIGSERIAL data types.