skip to main content
Supported data types : Progress Rollbase data types
 

Try DataDirect Cloud Now

Progress Rollbase data types

In communication between your application and the data store, data is mapped several times to the type appropriate for sending and receiving components. The following Rollbase attribute types are supported for JDBC and ODBC.
Table 18. Supported data types
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)