sqlite数据类型与c#数据类型对应表

database

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

 

转载自:https://www.cnblogs.com/swtool/p/8202965.html

以上是 sqlite数据类型与c#数据类型对应表 的全部内容, 来源链接: utcz.com/z/531392.html

回到顶部