Review the class-level translations for Sybase IQ InfoPrimer datatypes to Oracle datatypes for an EL or ETL project.
Sybase IQ InfoPrimer Datatype |
Oracle Datatype |
Size/Precision |
Minimum Scale |
Maximum scale |
|---|---|---|---|---|
binary |
BLOB |
2147483647 |
||
binary |
BFILE |
2147483647 |
||
binary |
RAW |
2000 |
0 |
0 |
string |
CLOB |
2147483647 |
0 |
0 |
string |
CHAR |
2000 |
0 |
0 |
float |
DECIMAL |
38 |
0 |
0 |
integer |
NUMBER |
38 |
0 |
0 |
float |
DOUBLE PRECISION |
15 |
0 |
38 |
datetime |
DATE |
19 |
0 |
0 |
datetime |
TIMESTAMP |
28 |
0 |
9 |
string |
VARCHAR2 |
4000 |
0 |
0 |
unicode |
NCHAR |
1000 |
0 |
0 |
unicode |
NVARCHAR2 |
2000 |
0 |
0 |
unicode |
NCLOB |
2147483647 |
0 |
0 |