| SQLite 数据类型 | C# 数据类型 | |
|---|
| BIGINT |
Int64 |
|
| BIGUINT |
UInt64 |
|
| BINARY |
Binary |
|
| BIT |
Boolean |
首选 |
| BLOB |
Binary |
首选 |
| BOOL |
Boolean |
|
| BOOLEAN |
Boolean |
|
| CHAR |
AnsiStringFixedLength |
首选 |
| CLOB |
String |
|
| COUNTER |
Int64 |
|
| CURRENCY |
Decimal |
|
| DATE |
DateTime |
|
| DATETIME |
DateTime |
首选 |
| DECIMAL |
Decimal |
首选 |
| DOUBLE |
Double |
|
| FLOAT |
Double |
|
| GENERAL |
Binary |
|
| GUID |
Guid |
|
| IDENTITY |
Int64 |
|
| IMAGE |
Binary |
|
| INT |
Int32 |
首选 |
| INT8 |
SByte |
|
| INT16 |
Int16 |
|
| INT32 |
Int32 |
|
| INT64 |
Int64 |
|
| INTEGER |
Int64 |
首选 |
| INTEGER8 |
SByte |
|
| INTEGER16 |
Int16 |
|
| INTEGER32 |
Int32 |
|
| INTEGER64 |
Int64 |
|
| LOGICAL |
Boolean |
|
| LONG |
Int64 |
|
| LONGCHAR |
String |
|
| LONGTEXT |
String |
|
| LONGVARCHAR |
String |
|
| MEMO |
String |
|
| MONEY |
Decimal |
|
| NCHAR |
StringFixedLength |
首选 |
| NOTE |
String |
|
| NTEXT |
String |
|
| NUMBER |
Decimal |
|
| NUMERIC |
Decimal |
|
| NVARCHAR |
String |
首选 |
| OLEOBJECT |
Binary |
|
| RAW |
Binary |
|
| REAL |
Double |
首选 |
| SINGLE |
Single |
首选 |
| SMALLDATE |
DateTime |
|
| SMALLINT |
Int16 |
首选 |
| SMALLUINT |
UInt16 |
首选 |
| STRING |
String |
|
| TEXT |
String |
|
| TIME |
DateTime |
|
| TIMESTAMP |
DateTime |
|
| TINYINT |
Byte |
首选 |
| TINYSINT |
SByte |
首选 |
| UINT |
UInt32 |
首选 |
| UINT8 |
Byte |
|
| UINT16 |
UInt16 |
|
| UINT32 |
UInt32 |
|
| UINT64 |
UInt64 |
|
| ULONG |
UInt64 |
|
| UNIQUEIDENTIFIER |
Guid |
首选 |
| UNSIGNEDINTEGER |
UInt64 |
首选 |
| UNSIGNEDINTEGER8 |
Byte |
|
| UNSIGNEDINTEGER16 |
UInt16 |
|
| UNSIGNEDINTEGER32 |
UInt32 |
|
| UNSIGNEDINTEGER64 |
UInt64 |
|
| VARBINARY |
Binary |
|
| VARCHAR |
AnsiString |
首选 |
| VARCHAR2 |
AnsiString |
|
| YESNO |
Boolean |
|
SQLite 数据类型与C#数据类型对应表
原文：https://www.cnblogs.com/lvdongjie/p/8879860.html
