欢迎加我的QQ群:193522571,一起来讨论、交流!
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 |
|
posted @
2018-01-05 10:47
swtool
阅读(
6288)
评论()
编辑
收藏
举报
欢迎加我的QQ群:193522571,一起来讨论、交流!