powerdesigner 数据类型与数据库数据类型对应

The following numeric data types are available:

Standard data typeDBMS-specific physical data typeContentLengthIntegerint / INTEGER32-bit integer—Short Integersmallint / SMALLINT16-bit integer—Long Integerint / INTEGER32-bit integer—Bytetinyint / SMALLINT256 values—Numbernumeric / NUMBERNumbers with a fixed decimal pointFixedDecimaldecimal / NUMBERNumbers with a fixed decimal pointFixedFloatfloat / FLOAT32-bit floating point numbersFixedShort Floatreal / FLOATLess than 32-bit point decimal number—Long Floatdouble precision / BINARY DOUBLE64-bit floating point numbers—Moneymoney / NUMBERNumbers with a fixed decimal pointFixedSerialnumeric / NUMBERAutomatically incremented numbersFixedBooleanbit / SMALLINTTwo opposing values (true/false; yes/no; 1/0)—

Character data types

The following character data types are available:

Standard data typeDBMS-specific physical data typeContentLengthCharacterschar / CHARCharacter stringsFixedVariable Charactersvarchar / VARCHAR2Character stringsMaximumLong Charactersvarchar / CLOBCharacter stringsMaximumLong Var Characterstext / CLOBCharacter stringsMaximumTexttext / CLOBCharacter stringsMaximumMultibytenchar / NCHARMultibyte character stringsFixedVariable Multibytenvarchar / NVARCHAR2Multibyte character stringsMaximum

Time data types

The following time data types are available:

Standard data typeDBMS-specific physical data typeContentLengthDatedate / DATEDay, month, year—Timetime / DATEHour, minute, and second—Date & Timedatetime / DATEDate and time—Timestamptimestamp / TIMESTAMPSystem date and time—

Other data types

The following other data types are available:

Standard data typeDBMS-specific physical data typeContentLengthBinarybinary / RAWBinary stringsMaximumLong Binaryimage / BLOBBinary stringsMaximumBitmapimage / BLOBImages in bitmap format (BMP)MaximumImageimage / BLOBImagesMaximumOLEimage / BLOBOLE linksMaximumOther—User-defined data type—UndefinedundefinedUndefined. Replaced by the default data type at generation.—