The following table describes the Oracle8i data types supported by the Migration Workbench:
|
Data Type |
Description |
|
VARCHAR |
The VARCHAR data type is currently synonymous with the VARCHAR2 data type. Oracle recommends that you use VARCHAR2 rather than VARCHAR. In the future, VARCHAR might be defined as a separate data type used for variable-length character strings compared with different comparison semantics. |
|
NCHAR |
Fixed-length character data of length size characters or bytes, depending on the choice of national character set. Maximum size is determined by the number of bytes required to store each character, with an upper limit of 2000 bytes. Default and minimum size is 1 character or 1 byte, depending on the character set. |
|
NUMBER |
Number having precision p and scale s. The precision p can range from 1 to 38. The scale s can range from -84 to 127. |
|
BLOB |
A binary large object. Maximum size is 4 gigabytes. |
|
DATE |
The DATE data type stores date and time information. Although date and time information can be represented in both CHAR and NUMBER data types, the DATE data type has special associated properties. For each DATE value, Oracle stores the following information: century, year, month, day, hour, minute, and second. |
|
LONG RAW |
Raw binary data of variable length up to 2 gigabytes. |
|
CLOB |
A character large object containing single-byte characters. Both fixed-width and variable-width character sets are supported, both using the CHAR database character set. Maximum size is 4 gigabytes. |
|
LONG |
Character data of variable length up to 2 gigabytes, or 231 -1 bytes. |
|
NVARCHAR2 |
Variable-length character string having maximum length size characters or bytes, depending on the choice of national character set. Maximum size is determined by the number of bytes required to store each character, with an upper limit of 4000 bytes. You must specify size for NVARCHAR2. |
|
RAW |
Raw binary data of length size bytes. Maximum size is 2000 bytes. You must specify size for a RAW value. |
|
NCLOB |
A character large object containing multi-byte characters. Both fixed-width and variable-width character sets are supported, both using the NCHAR database character set. Maximum size is 4 gigabytes. Stores national character set data. |
|
FLOAT |
Specifies a floating-point number with decimal precision 38, or binary precision 126. |
|
CHAR |
Fixed-length character data of length size bytes. Maximum size is 2000 bytes. Default and minimum size is 1 byte. |