Convertible Data Types

Previous Next

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.

Convertible Data Types

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

(*) Unicode data types are supported in USoft version 7.1 and higher.