0 Replies Latest reply on Sep 2, 2016 8:47 AM by nydn

    SQL Developer - Querying MySQL tinyint columns results in boolean

    nydn

      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