| 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