SQLite DataType

DbType.Boolean
BIT
YESNO
LOGICAL
BOOL

DbType.Byte
TINYINT

DbType.Int16
SMALLINT

DbType.Int32
INT

DbType.Int64
INTEGER
BIGINT
COUNTER
AUTOINCREMENT
IDENTITY
LONG

DbType.Single
REAL

DbType.Double
DOUBLE
FLOAT

DbType.Decimal
NUMERIC
DECIMAL
MONEY
CURRENCY

DbType.String
CHAR
NCHAR
VARCHAR
NVARCHAR
TEXT
NTEXT
LONGTEXT
LONGCHAR
LONGVARCHAR
STRING
MEMO
NOTE

DbType.Binary
BLOB
BINARY
VARBINARY
IMAGE
GENERAL
OLEOBJECT

DbType.Guid
GUID
UNIQUEIDENTIFIER

DbType.DateTime
TIME
DATE
DATETIME
SMALLDATE
SMALLDATETIME
TIMESTAMP

有两点需要注意:

SQLite 主键默认的 INTEGER 类型对应的是 Int64,而 INT 对应的是 Int32. 日期和时间类型最终存储为字符串,所以格式必须符合ISO8601标准: "yyyy-MM-dd HH:mm:ss","yyyyMMddHHmmss","yyyyMMddTHHmmssfffffff","yyyy-MM-dd","yy-MM-dd","yyyyMMdd","HH:mm:ss","THHmmss"

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!