|
Data Store data type
|
Intermediary data type
|
JDBC data type
|
ODBC data type
|
|
BOOLEAN
|
boolean
|
BOOLEAN
|
SQL_BIT(-7)
|
|
LONG
|
long
|
BIGINT
|
SQL_BIGINT(-5)
|
|
RELATIONSHIP
|
long
|
BIGINT
|
SQL_BIGINT(-5)
|
|
LONGREL
|
long
|
BIGINT
|
SQL_BIGINT(-5)
|
|
ORGDATA
|
long
|
BIGINT
|
SQL_BIGINT(-5)
|
|
STATUS
|
long
|
BIGINT
|
SQL_BIGINT(-5)
|
|
TEMPLATE
|
long
|
BIGINT
|
SQL_BIGINT(-5)
|
|
FILE
|
base64binary
|
LONGVARBINARY
|
SQL_LONGVARBINARY(-4)
|
|
IMAGE
|
base64binary
|
LONGVARBINARY
|
SQL_LONGVARBINARY(-4)
|
|
TEXT
|
string
|
LONGVARCHAR
|
SQL_LONGVARCHAR(-1) or SQL_WLONGVARCHAR(-10)
|
|
INT
|
int
|
INTEGER
|
SQL_INTEGER(4)
|
|
DOUBLE
|
double
|
DOUBLE
|
SQL_DOUBLE(8)
|
|
STRING
|
string
|
VARCHAR
|
SQL_VARCHAR(12) or SQL_WVARCHAR(-9)
|
|
ENCRYPTED
|
string
|
VARCHAR
|
SQL_VARCHAR(12) or SQL_WVARCHAR(-9)
|
|
PICKLIST
|
picklist
|
VARCHAR
|
SQL_VARCHAR(12) or SQL_WVARCHAR(-9)
|
|
LONGARR
|
string
|
VARCHAR
|
SQL_VARCHAR(12) or SQL_WVARCHAR(-9)
|
|
PUBAPPFILE
|
string
|
VARCHAR
|
SQL_VARCHAR(12) or SQL_WVARCHAR(-9)
|
|
AUTO
|
string
|
VARCHAR
|
SQL_VARCHAR(12) or SQL_WVARCHAR(-9)
|
|
DATE
|
date
|
DATE
|
SQL_TYPE_DATE(91)
|
|
TIME
|
time
|
TIME
|
SQL_TYPE_TIME(92)
|
|
DATETIME
|
dateTime
|
TIMESTAMP
|
SQL_TYPE_TIMESTAMP(93)
|