AutoCAD.Net/C#.Net QQ群:193522571 SQLServer与SQLlite数据库数据类型对应

bigint	DECIMAL	bigint
binary(n)	BINARY(n)	bytea(n)
bit	BIT	boolean, bool
char(n)	CHAR(n)	char(n)
datetime	DATETIME	timestamp(date, time)
decimal	DECIMAL	decimal
float	FLOAT	real, float4
image	IMAGE	bytea
int	INT	integer, int, int4
money	CURRENCY	decimal
nchar(n)	NCHAR(n)	char(n)
ntext	LONGTEXT	text
numeric	DECIMAL	numeric
nvarchar(n)	NCHAR VARYING(n)	varchar(n)
real	REAL	real
smalldatetime	DATETIME	timestamp(date, time)
smallint	SMALLINT	smallint, int2
smallmoney	CURRENCY	decimal
text	LONGTEXT	text
timestamp	BINARY	无
tinyint	BYTE	无
uniqueidentifier	GUID	无
varbinary(n)	VARBINARY(n)	bytea(n)
varchar(n)	VARCHAR(n)	varchar(n)