SQLite 数据类型与C#数据类型对应表

 

 

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