PowerDesigner数据类型对照表The following numeric data types are available:
Standard data type DBMS-specific physical
data type格林童话
Content Length
Integer int / INTEGER32-bit integer—Short Integer smallint / SMALLINT16-bit integer—Long Integer int / INTEGER32-bit integer—Byte tinyint / SMALLINT256 values—Number numeric / NUMBER Numbers with a fixed decimal point Fixed Decimal decimal / NUMBER Numbers with a fixed decimal point Fixed Float float / FLOAT32-bit floating point numbers Fixed Short Float real / FLOAT
Less than 32-bit point decimal
number
9月16—Long Float
double precision / BINARY
DOUBLE
忽略造句64-bit floating point numbers—Money money / NUMBER Numbers with a fixed decimal point Fixed
Serial numeric / NUMBER Automatically incremented
numbers
Fixed
Boolean bit / SMALLINT Two opposing values (true/fal;
yes/no; 1/0)
—
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 / VARCHAR2Character 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
The following time data types are available:
Standard data
type DBMS-specific physical data
type
Content Length
Date date / DATE Day, month, year—Time time / DATE
党委理论中心组
Hour, minute, and
cond
—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 Maxim
um OLE image / BLOB OLE links Maximum Other—Ur-defined data type—
Undefined undefined Undefined. Replaced by the default
data type at generation.
—
