原文:
关于powerdesigner中的data types说明
The following character data types are available:
这一堆的数据类型看着真是头大，弄个表格对照一下。
Numeric data types
Character data types
The following character data types are available:
| Standard data type | DBMS-specific physical data type | Content | Length |
|---|---|---|---|
| Characters | char / CHAR | Character strings | Fixed |
| Variable Characters | varchar / VARCHAR2 | Character strings | Maximum |
| Long Characters | varchar / CLOB | Character strings | Maximum |
| Long Var Characters | text / CLOB | Character strings | Maximum |
| Text | text / CLOB | Character strings | Maximum |
| Multibyte | nchar / NCHAR | Multibyte character strings | Fixed |
| Variable Multibyte | nvarchar / NVARCHAR2 | Multibyte character strings | Maximum |
Time data types
| Standard data type | DBMS-specific physical data type | Content | Length |
|---|---|---|---|
| Date | date / DATE | Day, month, year | — |
| Time | time / DATE | Hour, minute, and second | — |
| Date & Time | datetime / DATE | Date and time | — |
| Timestamp | timestamp / TIMESTAMP | System date and time | — |
Other data types
The following other data types are available:
| Standard data type | DBMS-specific physical data type | Content | Length |
|---|---|---|---|
| Binary | binary / RAW | Binary strings | Maximum |
| Long Binary | image / BLOB | Binary strings | Maximum |
| Bitmap | image / BLOB | Images in bitmap format (BMP) | Maximum |
| Image | image / BLOB | Images | Maximum |
| OLE | image / BLOB | OLE links | Maximum |
| Other | — | User-defined data type | — |
| Undefined | undefined | Undefined. Replaced by the default data type at generation. | — |
