|
Data Field Types and Corresponding MS SQL and ORACLE Data Types
The SAI360 field types are mapped as follows against Data Types:
SAI360 Data Field Type
|
ORACLE
|
MS-SQL
|
Date
|
DATE
|
DATETIME
|
Time
|
DATE
|
DATETIME
|
Number - Integer
|
NUMBER(4,0)
|
INT
|
Number - Float
|
NUMBER(38)
|
FLOAT
|
Text
|
NVARCHAR2(length), up to a length of 2000
|
NVARCHAR(length), up to a length of 4000
|
Text - Memo
|
LONG
|
NTEXT
|
Lookup
|
NVARCHAR2(18)
|
NVARCHAR2(18)
|
Matrix
|
NVARCHAR2(18)
|
NVARCHAR2(18)
|
Difference between Text and Memo Fields
- Text Fields
- are limited in the number of strings they can store
- Memo Fields
- can contain an unlimited amount of information
Therefore, you must use the correct field type which is appropriate for your needs.
|
