Convertible Data Types

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	Sybase/ OpenClient	Solid	Odbc
BINARY	RAW	BINARY	BINARY	BINARY	BINARY
BIT	RAW	BIT	BIT	BIT	BIT
BLOB	BLOB	IMAGE	IMAGE	LONG VARBINARY	LONG VARBINARY
BYTE	LONG RAW	IMAGE	IMAGE	LONG VARBINARY	LONG VARBINARY
CHAR	CHAR	CHAR	CHAR	CHAR	CHAR
CLOB	CLOB	TEXT	TEXT	LONG VARCHAR	LONG VARCHAR
DATE	DATE	DATETIME	DATETIME	DATE	DATE
DATETIME	DATE	DATETIME	DATETIME	DATE	DATE
DECIMAL	DECIMAL	DECIMAL	DECIMAL	DECIMAL	DECIMAL
DOUBLE PRECISION	FLOAT	FLOAT	FLOAT	FLOAT	FLOAT
FLOAT	FLOAT	FLOAT	FLOAT	FLOAT	FLOAT
FLOAT4	FLOAT4	REAL	REAL	REAL	REAL
IMAGE	LONG RAW	IMAGE	IMAGE	LONG VARBINARY	LONG VARBINARY
INT	INTEGER	INTEGER	INTEGER	INTEGER	INTEGER
INTEGER	INTEGER	INTEGER	INTEGER	INTEGER	INTEGER
LONG	LONG	TEXT	TEXT	LONG VARCHAR	LONG VARCHAR
LONG VARBINARY	LONG RAW	IMAGE	IMAGE	LONG VARBINARY	LONG VARBINARY
LONG VARCHAR	LONG	TEXT	TEXT	LONG VARCHAR	LONG VARCHAR
LONGRAW	LONG RAW	IMAGE	IMAGE	LONG VARBINARY	LONG VARBINARY
MONEY	NUMBER	MONEY	MONEY	FLOAT	FLOAT
NCHAR(*)	NCHAR	NCHAR	UNICHAR	WCHAR	WCHAR
NCLOB (*)	NCLOB	NTEXT	UNITEXT	LONG WVARCHAR	LONG WVARCHAR
NTEXT(*)	NCLOB	NTEXT	UNITEXT	LONG WVARCHAR	LONG WVARCHAR
NUMBER	NUMBER	NUMERIC	NUMERIC	NUMERIC	NUMERIC
NUMERIC	NUMERIC	NUMERIC	NUMERIC	NUMERIC	NUMERIC
NVARCHAR(*)	NVARCHAR2	NVARCHAR	UNIVARCHAR	WVARCHAR	WVARCHAR
NVARCHAR2(*)	NVARCHAR2	NVARCHAR	UNIVARCHAR	WVARCHAR	WVARCHAR
RAW	RAW	BINARY	BINARY	BINARY	BINARY
REAL	FLOAT	REAL	REAL	REAL	REAL
SMALLDATETIME	DATE	SMALLDATE TIME	SMALLDATETIME	DATE	DATE
SMALLINT	SMALLINT	SMALLINT	SMALLINT	SMALLINT	SMALLINT
SMALLMONEY	NUMBER	SMALLMONEY	SMALLMONEY	REAL	REAL
TEXT	LONG	TEXT	TEXT	LONG VARCHAR	LONG VARCHAR
TIME	DATE	DATETIME	DATETIME	DATE	DATE
TIMESTAMP	DATE	DATETIME	DATETIME	DATE	DATE
TINYINT	SMALLINT	TINYINT	TINYINT	TINYINT	TINYINT
UNICHAR(*)	NCHAR	NCHAR	UNICHAR	WCHAR	WCHAR
UNITEXT(*)	NCLOB	NTEXT	UNITEXT	LONG WVARCHAR	LONG WVARCHAR
UNIVARCHAR(*)	NVARCHAR2	NVARCHAR	UNIVARCHAR	WVARCHAR	WVARCHAR
VARBINARY	RAW	VARBINARY	VARBINARY	VARBINARY	VARBINARY
VARCHAR	VARCHAR	VARCHAR	VARCHAR	VARCHAR	VARCHAR
VARCHAR2	VARCHAR2	VARCHAR	VARCHAR	VARCHAR	VARCHAR
WCHAR(*)	NCHAR	NCHAR	UNICHAR	WCHAR	WCHAR
WLONGVARCHAR(*)	NCLOB	NTEXT	UNITEXT	LONG WVARCHAR	LONG WVARCHAR
WVARCHAR(*)	NVARCHAR2	NVARCHAR	UNIVARCHAR	WVARCHAR	WVARCHAR