KS DB Merge Tools logo KS DB Merge Tools
Documentation
KS DB Merge Tools for Cross-DBMS logo for Cross-DBMS
 
KS DB Merge Tools for Oracle logo
KS DB Merge Tools for MySQL logo
MssqlMerge logo
KS DB Merge Tools for PostgreSQL logo
KS DB Merge Tools for SQLite logo
AccdbMerge logo

SQLite Data Types

Here is a data type mapping from SQLite native data types to application generic data types. Any data type not listed in this table is mapped to Other generic data type.

Native data typeGeneric data type
BIGINTNumber
BLOBBinary
BOOLEANBoolean
CHARACTERString
CLOBString
DATEDateTime
DATETIMEDateTime
DECIMALNumber
DOUBLENumber
DOUBLE PRECISIONNumber
FLOATNumber
INTNumber
INT2Number
INT4Number
INT8Number
INTEGERNumber
MEDIUMINTNumber
NATIVE CHARACTERString
NCHARString
NUMERICNumber
NVARCHARString
REALNumber
SMALLINTNumber
STRINGString
TEXTString
TINYINTNumber
UNSIGNED BIG INTNumber
VARCHARString
VARYING CHARACTERString

Last updated: 2023-10-10