This Bugzilla instance is a read-only archive of historic NetBeans bug reports. To report a bug in NetBeans please follow the project's instructions for reporting issues.
When connected via jdbc:mysql and issuing a SELECT query for data where a table contains a column with a TINYINT value, the value in the visual result shows up as a checkbox. This should instead be an integer. My column is defined as: `question_no` tinyint(1) unsigned NOT NULL I will try to attach a screenshot of the visual result.
Created attachment 84819 [details] Screenshot of visual result showing checkbox instead of integer for TINYINT column
*** Issue 168928 has been marked as a duplicate of this issue. ***
The problem is, that MySQL JDBC driver w/ MySQL DB (at least ver.5.0) returns JDBC Type BIT for each TINYINT(1). The IDE cannot realize a correct type for such cases and there is no way how to workaround this. We can hope next releases the driver will fix this problem.
four years and nothing changed regarding driver?
(In reply to comment #4) > four years and nothing changed regarding driver? The driver is developed at mysql.com, it's not part of the netbeans project. You can change this default: http://dev.mysql.com/doc/refman/5.0/en/connector-j-reference-type-conversions.html Table 20.25, third row. Just adjust the jdbc url and you are go. Btw. this is closed "WONTFIX" what did you imply with this question?
Guys.. Can i just disable that checkbox rendering? Because i can't differ any value more that 0 between themselves: unchecked = 0, checked = 1 = 2 = 3 = 4 = 5 = 6 = 7 = 8 = 9 -_-