SQLite Data Types |
C # Data types |
|
BIGINT |
Int64 |
|
Biguint |
UInt64 |
|
BINARY |
Binary |
|
BIT |
Boolean |
Preferred |
Blob |
Binary |
Preferred |
BOOL |
Boolean |
|
BOOLEAN |
Boolean |
|
CHAR |
Ansistringfixedlength |
Preferred |
Clob |
String |
|
COUNTER |
Int64 |
|
CURRENCY |
Decimal |
|
DATE |
Datetime |
|
Datetime |
Datetime |
Preferred |
DECIMAL |
Decimal |
Preferred |
DOUBLE |
Double |
|
FLOAT |
Double |
|
General |
Binary |
|
Guid |
Guid |
|
IDENTITY |
Int64 |
|
IMAGE |
Binary |
|
Int |
Int32 |
Preferred |
INT8 |
SByte |
|
INT16 |
Int16 |
|
INT32 |
Int32 |
|
INT64 |
Int64 |
|
INTEGER |
Int64 |
Preferred |
INTEGER8 |
SByte |
|
INTEGER16 |
Int16 |
|
INTEGER32 |
Int32 |
|
INTEGER64 |
Int64 |
|
LOGICAL |
Boolean |
|
LONG |
Int64 |
|
LongChar |
String |
|
Longtext |
String |
|
LongVarChar |
String |
|
MEMO |
String |
|
Money |
Decimal |
|
NCHAR |
Stringfixedlength |
Preferred |
NOTE |
String |
|
NTEXT |
String |
|
Number |
Decimal |
|
NUMERIC |
Decimal |
|
NVARCHAR |
String |
Preferred |
OLEOBJECT |
Binary |
|
RAW |
Binary |
|
REAL |
Double |
Preferred |
Single |
Single |
Preferred |
Smalldate |
Datetime |
|
SMALLINT |
Int16 |
Preferred |
Smalluint |
UInt16 |
Preferred |
STRING |
String |
|
TEXT |
String |
|
Time |
Datetime |
|
TIMESTAMP |
Datetime |
|
TINYINT |
Byte |
Preferred |
Tinysint |
SByte |
Preferred |
UINT |
UInt32 |
Preferred |
UINT8 |
Byte |
|
UINT16 |
UInt16 |
|
UINT32 |
UInt32 |
|
UINT64 |
UInt64 |
|
ULONG |
UInt64 |
|
uniqueidentifier |
Guid |
Preferred |
Unsignedinteger |
UInt64 |
Preferred |
UNSIGNEDINTEGER8 |
Byte |
|
UNSIGNEDINTEGER16 |
UInt16 |
|
UNSIGNEDINTEGER32 |
UInt32 |
|
UNSIGNEDINTEGER64 |
UInt64 |
|
VARBINARY |
Binary |
|
VARCHAR |
Ansistring |
Preferred |
VARCHAR2 |
Ansistring |
|
YESNO |
Boolean |
|
SQLite data type corresponds to C # data type table