To display a list of default data types, choose Options | Data types from the Scriptoria main menu.
The following form shows initial data type settings. The data type values are applied to all tables that are converted to Oracle.
When creating Oracle table columns, equivalent Oracle data types are substituted for Access types. You can specify global defaults for each type, and optionally assign different types for individual table columns. Global types are substituted whenever a column has not been individually assigned a data type.
|
Access Data Types |
Equivalent Oracle Data Types
|
|
|
|
|
Yes/No |
Defaults to NUMBER(1,0); |
|
Byte |
Defaults to NUMBER(3,0); |
|
Integer |
Defaults to NUMBER(5,0); |
|
Long |
Defaults to NUMBER(10,0); Alternative combo-box entry is NUMBER. |
|
Currency |
Defaults to NUMBER(19,4); Alternative combo-box entry is NUMBER(15,2). Note that using designating a NUMBER column with a size greater that 15, for example NUMBER(16), will be interpreted as a Text field when linked using ODBC with Access 97. For Access 97, use NUMBER (15,2). |
|
Single |
Defaults to NUMBER; Alternative combo-box entry is FLOAT. |
|
Double |
Defaults to NUMBER; Alternative combo-box entry is FLOAT. |
|
Date |
Defaults to Date; The alternative combo-box entry for DATE is TIMESTAMP. TIMESTAMP is supported by Oracle9i and later. Do not use TIMESTAMP when you wish to retain the MS-Access front-end. ODBC treats DATE and TIMESTAMP identically. |
|
Text |
Defaults to VARCHAR2; Alternative combo-box entry is CHAR. The length of the Access field is supplied with the CHAR and VARCHAR2 data type definition, e.g. CHAR(50)). |
|
OLE Object |
Defaults to BLOB (requires Oracle 8i or higher). Alternative entry LONG RAW (USE WITH Oracle 7.3 only). Note that only one LONG (or LONG RAW) column may be defined in an Oracle 7.3 table. This restriction does not apply when using BLOB. |
|
Memo |
Defaults to CLOB. Alternative combo-box entries are VARCHAR2(500), VARCHAR2(1000), VARCHAR2(2000) and VARCHAR2(4000). |
|
AutoNumber |
Defaults to NUMBER(10,0); Alternative combo-box entry is NUMBER. |