Forum Stats

  • 3,770,053 Users
  • 2,253,055 Discussions
  • 7,875,284 Comments

Discussions

SQL Developer - Querying MySQL tinyint columns results in boolean

nydn
nydn Member Posts: 16 Red Ribbon
edited Sep 2, 2016 6:12AM in SQL Developer

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

Tagged:
This discussion has been closed.