IceTea.SqlCreator 1.0.5

<Center><H1>C#和数据库类型映射表</H1></Center>

• Sqlite

  宽类型	详细类型	C#
  INTEGER	INT	Int32
  INTEGER	INTEGER	Int64
  INTEGER	TINYINT	Byte
  INTEGER	SMALLINT	Int16
  INTEGER	MEDIUMINT	Int32
  INTEGER	BIGINT	Int64
  INTEGER	UNSIGNED BIG INT	Object
  INTEGER	INT2	Object
  INTEGER	INT8	SByte
  NUMERIC	NUMERIC	Decimal
  NUMERIC	DECIMAL(10,5)	Decimal
  NUMERIC	BOOLEAN	Boolean
  NUMERIC	DATE	DateTime
  NUMERIC	DATETIME	DateTime
  REAL	REAL	Double
  REAL	DOUBLE	Double
  REAL	DOUBLE PRECISION	Object
  REAL	FLOAT	Double
  TEXT	CHARACTER(20)	Object
  TEXT	VARCHAR(255)	String
  TEXT	VARYING CHARACTER(255)	Object
  TEXT	NCHAR(55)	String
  TEXT	NATIVE CHARACTER(70)	Object
  TEXT	NVARCHAR(100)	String
  TEXT	TEXTCLOB	Object

• Mysql

  Mysql 类型	C#
  bit(1)	UInt64
  tinyint(1)	Boolean
  bigint(20)	Int64
  bigint(20) unsigned	UInt64
  binary(1)	Byte[]
  blob	Byte[]
  char(1)	String
  date	DateTime
  datetime	DateTime
  decimal(10,0)	DECIMAL
  double	Double
  float	Single
  int(11)	Int32
  int(10) unsigned	UInt32
  mediumblob	Byte[]
  mediumtext	String
  longblob	Byte[]
  longtext	String
  mediumint(9)	Int32
  mediumint(8) unsigned	UInt32
  smallint(6)	Int16
  smallint(5) unsigned	UInt16
  text	String
  time	TimeSpan
  timestamp	DateTime
  tinyblob	Byte[]
  tinyint(4)	SByte
  tinyint(3) unsigned	Byte
  String	tinytext
  varbinary(100)	Byte[]
  varchar(100)	String
  year(4)	Int16
  json	String

• Postgresql

  Postgresql 类型	C#
  bit(1)	Boolean
  bool	Boolean
  bigserial	Int64
  int8	Int64
  serial4	Int32
  int4	Int32
  smallserial	Int16
  int2	Int16
  float8	Double
  float4	Single
  bytea	Byte[]
  date	DateTime
  timestamp	DateTime
  time	TimeSpan
  varchar(100)	String
  text	String
  numeric	DECIMAL
  money	DECIMAL

• SqlServer

  SqlServer 类型	C#
  bit	Boolean
  bigint	Int64
  int	Int32
  smallint	Int16
  float	Double
  real	Single
  date	DateTime
  smalldatetime	DateTime
  datetime	DateTime
  time(0)	TimeSpan
  varchar(100)	String
  text	String
  money	DECIMAL
  decimal(38,0)	DECIMAL
  image	Byte[]
  binary	Byte[]
  varbinary(1024)	Byte[]
  uniqueidentifier	Guid
  uniqueidtinyintentifier	Byte