Skip to Main Content
Forums

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

SQL Developer - Querying MySQL tinyint columns results in boolean

nydnSep 2 2016 — edited Sep 2 2016

Good morning,

As the subject states, when I query a MySQL DB in SQL Developer via the mysql java connector, Tinyint type columns are returned as a boolean type.

> desc status;

row_id     tinyint

name       varchar

> select * from status;

true     Active

true     Archive

true     Inactive

true     Deleted

But it should be:

1        Active

2        Archive

3        Inactive

4        Deleted

I've tried the same query in a simple java program with the same jdbc driver, to test the mysql driver and no problem there, tinyints are returned as numbers.

The database connection is set up with the official MySQL Java connector (ver 5.1.39).

SQL Developer version 4.1.3.20.78

Java version 1.8.0

Regards,

Daniel

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Sep 30 2016
Added on Sep 2 2016
#jdbc, #mysql, #sql-developer
0 comments
411 views