|
Convertible data types are native to the RDBMS that you develop your application in. These data types are automatically mapped to the equivalent type used by USoft, and vice versa.
The table below lists the USoft data types, with equivalent data types for supported RDBMSs.
USoft
|
Oracle
|
SQL Server/
Oledb
|
Odbc
|
Derby
|
BINARY
|
RAW
|
BINARY
|
BINARY
|
BINARY
|
BIT
|
RAW
|
BIT
|
BIT
|
VARCHAR
|
BLOB
|
BLOB
|
VARBINARY( max )
|
LONG VARBINARY
|
BLOB
|
BYTE
|
LONG RAW
|
IMAGE
|
LONG VARBINARY
|
VARCHAR
|
CHAR
|
CHAR
|
CHAR
|
CHAR
|
CHAR
|
CLOB
|
CLOB
|
VARCHAR( max )
|
LONG VARCHAR
|
CLOB
|
DATE
|
DATE
|
DATETIME
|
DATE
|
TIMESTAMP
|
DATETIME
|
DATE
|
DATETIME
|
DATE
|
VARCHAR
|
DECIMAL
|
DECIMAL
|
DECIMAL
|
DECIMAL
|
DECIMAL
|
DOUBLE PRECISION
|
FLOAT
|
FLOAT
|
FLOAT
|
VARCHAR
|
FLOAT
|
FLOAT
|
FLOAT
|
FLOAT
|
NUMERIC
|
FLOAT4
|
FLOAT4
|
REAL
|
REAL
|
VARCHAR
|
IMAGE
|
LONG RAW
|
IMAGE
|
LONG VARBINARY
|
VARCHAR
|
INT
|
INTEGER
|
INTEGER
|
INTEGER
|
VARCHAR
|
INTEGER
|
INTEGER
|
INTEGER
|
INTEGER
|
INTEGER
|
LONG
|
LONG
|
TEXT
|
LONG VARCHAR
|
VARCHAR
|
LONG VARBINARY
|
LONG RAW
|
IMAGE
|
LONG VARBINARY
|
VARCHAR
|
LONG VARCHAR
|
LONG
|
TEXT
|
LONG VARCHAR
|
VARCHAR
|
LONGRAW
|
LONG RAW
|
IMAGE
|
LONG VARBINARY
|
VARCHAR
|
MONEY
|
NUMBER
|
MONEY
|
FLOAT
|
NUMERIC
|
NCHAR
|
NCHAR
|
NCHAR
|
WCHAR
|
VARCHAR
|
NCLOB
|
NCLOB
|
NVARCHAR( max )
|
LONG WVARCHAR
|
VARCHAR
|
NTEXT
|
NCLOB
|
NTEXT
|
LONG WVARCHAR
|
VARCHAR
|
NUMBER
|
NUMBER
|
NUMERIC
|
NUMERIC
|
NUMERIC
|
NUMERIC
|
NUMERIC
|
NUMERIC
|
NUMERIC
|
NUMERIC
|
NVARCHAR
|
NVARCHAR2
|
NVARCHAR
|
WVARCHAR
|
VARCHAR
|
NVARCHAR2
|
NVARCHAR2
|
NVARCHAR
|
WVARCHAR
|
VARCHAR
|
RAW
|
RAW
|
BINARY
|
BINARY
|
VARCHAR
|
REAL
|
FLOAT
|
REAL
|
REAL
|
VARCHAR
|
SMALLDATETIME
|
DATE
|
SMALLDATE
TIME
|
DATE
|
VARCHAR
|
SMALLINT
|
SMALLINT
|
SMALLINT
|
SMALLINT
|
SMALLINT
|
SMALLMONEY
|
NUMBER
|
SMALLMONEY
|
REAL
|
NUMERIC
|
TEXT
|
LONG
|
TEXT
|
LONG VARCHAR
|
CLOB
|
TIME
|
DATE
|
DATETIME
|
DATE
|
VARCHAR
|
TIMESTAMP
|
DATE
|
DATETIME
|
DATE
|
VARCHAR
|
TINYINT
|
SMALLINT
|
TINYINT
|
TINYINT
|
VARCHAR
|
UNICHAR
|
NCHAR
|
NCHAR
|
WCHAR
|
VARCHAR
|
UNITEXT
|
NCLOB
|
NTEXT
|
LONG WVARCHAR
|
VARCHAR
|
UNIVARCHAR
|
NVARCHAR2
|
NVARCHAR
|
WVARCHAR
|
VARCHAR
|
VARBINARY
|
RAW
|
VARBINARY
|
VARBINARY
|
VARBINARY
|
VARCHAR
|
VARCHAR
|
VARCHAR
|
VARCHAR
|
VARCHAR
|
VARCHAR2
|
VARCHAR2
|
VARCHAR
|
VARCHAR
|
VARCHAR
|
WCHAR
|
NCHAR
|
NCHAR
|
WCHAR
|
VARCHAR
|
WLONGVARCHAR
|
NCLOB
|
NTEXT
|
LONG WVARCHAR
|
VARCHAR
|
WVARCHAR
|
NVARCHAR2
|
NVARCHAR
|
WVARCHAR
|
VARCHAR
|
|
