PowerDesigner data type corresponds to the database data type __ Database

The following numeric data types are available:

Standard Data Type	dbms-specific Physical Data type	Content	Length
Integer	Int/integer	32-bit integer	—
Short Integer	Smallint/smallint	16-bit integer	—
Long Integer	Int/integer	32-bit integer	—
Byte	Tinyint/smallint	256 values	—
Number	Numeric/number	Numbers with a fixed decimal point	Fixed
Decimal	Decimal/number	Numbers with a fixed decimal point	Fixed
Float	Float/float	32-bit floating point numbers	Fixed
Short Float	Real/float	Less than 32-bit point decimal number	—
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/false; yes/no; 1/0)	—

Character Data types

The following character data types are available:

Standard data type	dbms-specific physical data type	Content	lengt H
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	Maximu M

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 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:

td>undefined

Standard data type	dbms-specific physical data type	content	Length
Binary	binary/raw	Binary strings	M Aximum
Long Binary	image/blob	Binary strings	Maximu M
Bitmap	image/blob	Images in Bitmap format (BMP)	M Aximum
Image	image/blob	Images	Maximum
OLE	image/blob	OLE links	Maximum
Other	-	user-defined data type	-
Undefined	undefined. Replaced by the default data type at generation.	-