Oracle Data Types (Magic xpa 2.x)
The following table shows the results of a Magic xpa Get Definition operation from an Oracle table, and shows Magic xpa equivalents for Oracle database data types.
|
Oracle Data Type
|
Attribute
|
Magic xpa Storage Type
|
Storage Size
|
Picture
|
|
CHAR(n)
VARCHAR2(n)
|
Alpha
|
Zstring
|
n+1,2-4001
|
n,1-4000
|
|
LONG
|
Blob
|
Ansi
|
|
|
|
LONG RAW
|
Blob
|
Binary
|
|
|
|
RAW (n)
|
Blob
|
Binary
|
|
|
|
NUMBER
|
Numeric
|
Float
|
8
|
4.3
|
|
NUMBER (p,s)
|
Numeric
|
Float
|
8
|
p-s,s
|
|
NUMBER (p)
|
Numeric
|
Float
|
8
|
p
|
|
DATE
|
1. Date
2. Time
|
Creates two fields, one with String Date and one with String Time, that are connected by the Part of Datetime property.
|
8
|
DD/MM/YYYY
|
|
ROWID
|
Alpha
|
Zstring
|
19
|
18
|
|
NVARCHAR2
|
Unicode
|
ZUnicode
|
n*2+2
|
n,1-2000
|
|
NCHAR
|
Unicode
|
ZUnicode
|
n*2+2
|
n,1-2000
|
|
CLOB
|
Blob
|
Ansi
|
|
|
|
BLOB
|
Blob
|
Binary
|
|
|
|
NCLOB
|
Blob
|
Unicode
|
|
|
|
Note:
|
-
After getting the table’s definition you must set the picture for LONG and LONG RAW data type columns to the appropriate size for your project.
-
When you use the Magic xpa Get Definition utility, Magic xpa will ask you if you want to separate the Oracle DATE data type into two Magic xpa data types, one Date and one Time, which will be connected by the Part of Datetime property.
-
To see all parts of a DATE column in the format ‘YYYY/MM/DD HH:MM:SS.mmm’ and map to an Alpha attribute, you should map the Oracle DATE datatype to Magic xpa’s Alpha attribute. This can be done by specifying ‘SQL_DATETOALPHA=Y’ in the Database Information field in the Database Properties dialog box.
-
The storage size is calculated according to the database of the table - according to the gateway's storage table. The storage size is recalculated on import.
|
