PD12概念模型 | SQLServer2005 | Oracle 10g | 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 |
PD12概念模型中各数据类型与主流数据库数据类型对照
PowerDesign12概念模型中各数据类型与SqlServer2005、Oracle10g、MySql5数据类型对照见下表:
rel="File-List" href="file:///C:/DOCUME~1/ADMINI~1/LOCALS~1/Temp/msohtml1/01/clip_filelist.xml" />