MySQL

MySQL: Error connecting
Connecting to MySQL may result in various errors. See below for some of the most common. The solutions are based on that at least DbVisualizer 12.1.3 is...
Wed, 22 May, 2024 at 11:49 AM
MySQL: Value '0000-00-00' can not be represented as java.sql.Timestamp
Accessing a table in the Data tab or in the SQL Commander that contain a DATETIME column sometimes report the following error and highlights the column in...
Mon, 11 Dec, 2017 at 11:12 AM
MySQL: TINYINT(1) values are displayed as true/false instead of number
This behaviour is due to the MySQL database driver that handles tinyint(1) as bit by default. To change this, open the connection, navigate to the Prope...
Mon, 18 Mar, 2024 at 11:13 PM
MySQL: Connecting securely to a MySQL server
MySQL supports both encryption and secure authentication. This solution describes how to connect using DbVisualizer to a secured mySQL server. The descripti...
Wed, 17 Feb, 2021 at 11:34 PM
MySQL: Column aliases are not displayed as column headers in result sets
I can't see bar as column header in the result set for the following query. I always get foo. select foo as 'bar' from mytable Solution: In t...
Wed, 12 Jul, 2017 at 7:55 PM
MySQL: YEAR values are displayed as dates
Formatting of YEAR values is controlled by the MySQL driver, and by default they are displayed as dates (for more information, please see https://dev.mysql....
Fri, 22 Mar, 2024 at 10:26 AM
MySQL: com.mysql.cj.jdbc.exceptions.MysqlDataTruncation: Data truncation: Cannot create a JSON value from a string with CHARACTER SET 'binary'
Using the inline editor for JSON columns can result in the MysqlDataTruncation problem. Solution: In the connection tab check Buffer All Rows for a Res...
Wed, 12 Jun, 2024 at 3:54 PM