MySQL tinyint(1) maps wrongly

A Java SQL client for any JDBC compliant database

Brought to you by: colbell, gerdwagner

#1407 MySQL tinyint(1) maps wrongly

Milestone: SQuirreL

Status: closed-wont-fix

Owner: nobody

Labels: None

Priority: medium

Updated: 2019-10-12

Created: 2019-10-02

Creator: Victor Porton

Private: No

MySQL tinyint(1) is shown in SQuirell as BIT(1) and values are displayed as true or false, what is very wrong because this type can take other values than 0 and 1.

1 Attachments

MySqlTinyTest.java

Discussion

Gerd Wagner - 2019-10-12

status: open --> closed-wont-fix

Attachments has changed:

Diff:

--- old +++ new @@ -0,0 +1 @@ +MySqlTinyTest.java (818 Bytes; text/x-java)
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Gerd Wagner - 2019-10-12

This is a RDBMS or JDBC driver problem, see attached MySqlTinyTest.java.

Please consult the MySQL team.

Gerd

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

MySQL tinyint(1) maps wrongly

A Java SQL client for any JDBC compliant database

Group

Searches

Help

#1407 MySQL tinyint(1) maps wrongly

Discussion