DataDirect driver treats MySQL TINYINT data type as boolean
Article ID: KB0094111
Updated On:
| Products | Versions |
|---|---|
| TIBCO ActiveMatrix BusinessWorks | - |
| Not Applicable | - |
Description
Resolution:
If you create a table with a column of tinyint data type and if you use DataDirect driver to query the table, BW treats the tinyint type as a boolean type.
MySQL supports the SQL standard integer types
INTEGER (or INT) and SMALLINT. As an extension to the standard, MySQL also supports the integer types TINYINT, MEDIUMINT, and BIGINT. TINYINT is a MySQL specific data type. It takes one byte iof storage. The minimum value is -128 and maximum value is 127. If you want to work
with tinyint, you may use the MySQL JDBC driver instead of the TIBCO DataDirect JDBC driver.Issue/Introduction
DataDirect driver treats MySQL TINYINT data type as boolean
Additional Information
Feedback
Yes
No
Powered by
