Previous topic  Top  Next topic  Print this Topic
 

Supported Common Datatypes

 

If there is no ObjectLogic Constant (-), this means that this JDBC datatype is not supported by our tools.

JDBC  data type

ObjectLogic Constants

ARRAY

-

BIGINT

INTEGER

BINARY        

-

BIT        

BOOLEAN

BLOB

-

BOOLEAN

BOOLEAN

CHAR

STRING

CLOB

-

DATALINK

-

DATE

DATE

DECIMAL

DECIMAL

DISTINCT

-

DOUBLE

DOUBLE

FLOAT

DOUBLE

INTEGER

INT

JAVA_OBJECT

-

LONGNVARCHAR

STRING

LONGVARBINARY

-

NCHAR

STRING

NCLOB

-

NULL

-

NUMERIC

DECIMAL

NVARCHAR

STRING

OTHER

-

REAL

DECIMAL

REF

-

ROWID

-

SMALLINT

INT

SQLXML

-

STRUCT

-

TIME

TIME

TIMESTAMP

DATETIME

TINYINT

INT

VARBINARY

-

VARCHAR

-

Additional Database-Specific Data Types

Oracle

Oracle data type

ObjectLogicConstants

NVARCHAR2

STRING