PD12概念模型中各数据类型与主流数据库数据类型对照

PD12概念模型中各数据类型与主流数据库数据类型对照  

 

P ower Design12概念模型中各数据类型与SqlServer2005、Oracle10g、MySql5数据类型对照见下表：

PD12概念模型	SQLServer2005	Oracle10g	MySql5.0
Integer	Int	Integer	Int
Short integer	Smallint	Smallint	Smallint
Long integer	Bigint	Integer	Bigint
Byte	Tinyint	Smallint	Tinyint
Number	Numeric	Number	Numeric(8,0)
Decimal	Decimal	Number	Decimal
Float	Float	Float	Float
Short float	Real	Float	Real
Long float	Double precision	Binary_double	Double
Money	Money	Number(8,2)	Float(8,2)
Serial	Numeric	Number(6)	Int
Boolean	Bit	Smallint	Bool

Characters	Char	Char	Char
Variable characters	Varchar	Varchar2	Varchar
Long characters	Varchar	Clob	Long text
Long variable characters	Varchar	Clob	Long text
Text	Text	clob	Text
Multibyte	Nchar	Nchar	National char
Variable multibyte	Nvarchar	Nvarchar2	National char
Date	Datetime	Date	Date
Time	Datetime	Date	Time
Date&Time	Datetime	Date	Datetime
Timestamp	Timestamp	Timestamp	Timestamp
Binary	Binary	Row	Blob
Long binary	Varbinary	Blob	Longblob
Bitmap	Image	Blob	Longblob
Image	Image	Blob	Longblob
OLE	Image	Blob	Longblob