Data Types
- Last Updated: May 18, 2020
- 1 minute read
- DataDirect Connectors
- JDBC
- IBM Db2 5.1
- MySQL 5.1
- Progress OpenEdge 5.1
- SAP Sybase 5.1
- Documentation
The following table lists the data types supported by the Progress OpenEdge driver and how they are mapped to the JDBC data types.
| Progress OpenEdge Data Type | JDBC Data Type |
|---|---|
| bigint | BIGINT |
| binary | BINARY |
| bit | BIT |
| blob | LONGVARBINARY |
| character | CHAR |
| clob | LONGVARCHAR |
| date | DATE |
| double precision | DOUBLE |
| float | DOUBLE |
| integer | INTEGER |
| lvarbinary | LONGVARBINARY |
| lvarchar | LONGVARCHAR |
| numeric | NUMERIC |
| real | REAL |
| smallint | SMALLINT |
| time | TIME |
| timestamp | TIMESTAMP |
| timestamp with time zone | CHAR |
| tinyint | TINYINT |
| varbinary | VARBINARY |
| varchar | VARCHAR |