Alpha - Oracle (Magic xpa 2.x)
The table below lists Magic xpa’s Alpha attribute with the valid Oracle data types.
Each entry in the table has a default data type that can be forced by specifying that type in the Type property of the SQL section in the Column Properties sheet.
Note: n is the specified picture number.
|
Magic xpa Storage Type
|
Magic xpa Picture
|
Magic xpa Storage Size
|
Oracle Data Type
|
|
String
|
n,1-4000
|
n,1-4000
|
VARCHAR2
|
|
|
n, 4001-32700
|
n, 4001-32700
|
CLOB
|
|
Lstring
|
n, 1-255
|
n+1, 2-256
|
VARCHAR2
|
|
Zstring
|
n, 1-4000
|
n+1, 2-4001
|
VARCHAR2
|
|
|
n, 4001-32700
|
n+1, 4002-32701
|
CLOB
|
|
String Memo
|
n, 1-1998
|
n+2
|
RAW
|
|
Magic Memo
|
n, 1999 and above
|
n+2
|
LONG RAW
|
