Softpedia >Windows >Internet >Servers >Database Utils >Navicat for MySQL >  Changelog

Navicat for MySQL Changelog

What's new in Navicat for MySQL 16.3.9

Apr 16, 2024
  • Bug-fixes:
  • Incorrect SQL format when dumping Mariadb table.
  • Syntax error occurred when transferring tables with escape characters.
  • Minor bug fixes and improvements.

New in Navicat for MySQL 16.3.8 (Feb 29, 2024)

  • Minor bug fixes and improvements.

New in Navicat for MySQL 16.3.7 (Feb 21, 2024)

  • Bug-fixes:
  • Crashed when importing paradox files.
  • Failed to import JSON file from web service.
  • Refresh button did not work in Server Monitor.
  • Some labels disappeared after adding the chart to the dashboard.
  • Unable to display proportion percentages in the chart axis.
  • Minor bug fixes and improvements.

New in Navicat for MySQL 16.3.5 (Jan 11, 2024)

  • Bug-fixes:
  • The percentage values shown in the chart were incorrect.
  • Not all data was imported when scheduling import.
  • Unknown Internal Error occurred when importing data.
  • The comment code shortcut did not work in some cases.
  • Unknown Internal Error occurred when transferring data.
  • Minor bug fixes and improvements.

New in Navicat for MySQL 16.3.3 (Dec 5, 2023)

  • Improvements:
  • Support enabling or disabling "Detect Data Types" in Import Wizard.
  • Support ssh agent using pageant unix mode.
  • Bug-fixes:
  • Minor bug fixes and improvements.

New in Navicat for MySQL 16.3.2 (Nov 7, 2023)

  • Minor bug fixes and improvements.

New in Navicat for MySQL 16.3.0 (Oct 17, 2023)

  • Improvements:
  • Support setting MySQL descending primary key.
  • Bug-fixes:
  • Minor bug fixes and improvements.

New in Navicat for MySQL 16.2.11 (Oct 4, 2023)

  • Bug-fixes:
  • Crashed when opening Charts workspaces in some cases.
  • Missing parameters when transferring MariaDB Functions.
  • Crashed when scheduling import jobs.
  • 1064 error occurred when running query to create stored procedure in some cases.
  • Missing records when importing files in some cases.
  • Special characters were garbled when using double-click to add a snippet to the query.
  • Incorrect database list was shown in the connection window when using dark mode.

New in Navicat for MySQL 16.2.10 (Sep 7, 2023)

  • Crashed when importing Access files.
  • Minor bug fixes and improvements.

New in Navicat for MySQL 16.2.8 (Aug 29, 2023)

  • Improvements:
  • Auto guess field types when importing xlsx files.
  • Bug-fixes:
  • Beautify SQL incorrectly added spaces between the function name and parentheses.
  • Minor bug fixes and improvements.

New in Navicat for MySQL 16.2.7 (Aug 14, 2023)

  • Bug-fixes:
  • Incorrectly triggering code completion when pressing ENTER in Query Editor.
  • Minor bug fixes and improvements.
  • To upgrade, please visit our Customer Center.

New in Navicat for MySQL 16.2.6 (Aug 8, 2023)

  • Bug-fixes:
  • Unable to close tabs in some cases.
  • Slashes () were removed from triggers when synchronizing MariaDB structures.
  • Minor bug fixes and improvements.

New in Navicat for MySQL 16.2.5 (Jul 14, 2023)

  • Bug-fixes:
  • Cannot type a new name for the table in Import Wizard.
  • Minor bug fixes and improvements.

New in Navicat for MySQL 16.2.3 (Jun 20, 2023)

  • Bug-fixes:
  • Expressions for virtual columns were truncated.
  • Minor bug fixes and improvements.

New in Navicat for MySQL 16.2.2 (Jun 9, 2023)

  • Improvements:
  • Support unix socket forwarding in SSH.
  • Bug-fixes:
  • Minor bug fixes and improvements.

New in Navicat for MySQL 16.2.1 (May 31, 2023)

  • Main New Features:
  • Support sequence design for MariaDB.
  • Show fields, indexes and more under tables in Navigation Pane.
  • Minor bug fixes and improvements.
  • Navicat for Redis is released.

New in Navicat for MySQL 16.1.15 (Apr 26, 2023)

  • Bug-fixes:
  • High CPU usage when using SSH connection.
  • Minor bug fixes and improvements.

New in Navicat for MySQL 16.1.12 (Apr 17, 2023)

  • Query Builder window was larger than the screen in some cases.
  • Unable to display the data differences of TEXT fields in Data Synchronization.
  • The second field was selected when adding a sort condition in Table Viewer.
  • Crashed when stopping Data Transfer process.
  • Minor bug fixes and improvements.

New in Navicat for MySQL 16.1.10 (Mar 13, 2023)

  • Minor bug fixes and improvements.

New in Navicat for MySQL 16.1.9 (Mar 2, 2023)

  • Memory utilization issue.
  • Table Viewer did not show the SQL if errors occurred.
  • Minor bug fixes and improvements.

New in Navicat for MySQL 16.1.8 (Feb 9, 2023)

  • Bug-fixes:
  • Unable to save changes after deleting a cell value in Table Viewer.
  • Access violation error occurred when opening a model.
  • Minor bug fixes and improvements

New in Navicat for MySQL 16.1.6 (Dec 13, 2022)

  • "Cannot open source table" error occurred when using Condition Query in Import Wizard.
  • Exporting to Excel file was slow.
  • Minor bug fixes and improvements.

New in Navicat for MySQL 15.0.29 (Dec 5, 2022)

  • Bug fixes:
  • Failed to transfer large tables.
  • Crashed when batch querying tables with FK dependency.
  • Unknown Internal Error occurred when exporting large amount of data.
  • Minor bug fixes and improvements.

New in Navicat for MySQL 16.1.4 (Nov 21, 2022)

  • Bug-fixes:
  • 1267 error occurred when clicking the "Users" button.
  • Bar chart label display issue.
  • Unable to export Excel file in some cases.
  • Hanged when transferring tables.
  • Minor bug fixes and improvements.

New in Navicat for MySQL 16.1.3 (Sep 28, 2022)

  • Bug-fixes:
  • Unable to connect server using HTTP tunnel in some cases.
  • Font size issue in Form View.
  • Buttons in the lower right corner of the main window were missing in some cases.
  • Minor bug fixes and improvements.

New in Navicat for MySQL 16.1.2 (Aug 31, 2022)

  • Bug-fixes:
  • Crashed when changing the chart type in some cases.
  • Hanged when deleting a table in Query Builder.
  • Text color issue in Dark Mode.
  • Unable to connect AWS RDS database via SSH.
  • Backup and Dump SQL File was slow in some cases.
  • Minor bug fixes and improvements.

New in Navicat for MySQL 16.1.1 (Aug 16, 2022)

  • Bug fixes:
  • Unable to open the objects in the "Find in Database" window.
  • The first number of every value in the list was removed in the table filter.
  • Unknown Internal Error occurred when updating query results in some cases.
  • Unable to use "Copy As" in View results.
  • Crashed when opening functions in some cases.
  • Unknown Internal Error occurred when foreign key selection window popped up.
  • Crashed when clicking on the value box in table filter.
  • Cannot retain the window size and position for existing objects.
  • Minor bug fixes and improvements.

New in Navicat for MySQL 16.0.14 (Jun 14, 2022)

  • Query parameters did not work in some cases.
  • Decimal precision issue when importing from Excel files.
  • Minor bug fixes and improvements.

New in Navicat for MySQL 16.0.13 (May 16, 2022)

  • Bug-fixes:
  • Crashed when opening large tables.
  • Incorrect MySQL auto increment value in Table Designer.
  • Minor bug fixes and improvements.

New in Navicat for MySQL 16.0.11 (Mar 29, 2022)

  • Crashed when running Automation in some cases.
  • Missing the first record when import.
  • Unable to locate project when running batch job.
  • Unable to get table information when scheduling data synchronization.
  • Refresh button ran all SQLs in Query Editor.
  • .0000 data export issue.
  • Function execution message log issue.
  • Access Violation error occurred when removing default value.
  • Navicat exited when clicking the Type column in Table Designer.
  • Crashed when batch querying tables with FK dependency.
  • Minor bug fixes and improvements.

New in Navicat for MySQL 16.0.9 (Jan 13, 2022)

  • Bug-fixes:
  • The "Compare" button did not work in Data Synchronization in some cases.
  • "Couldn't open known_hosts file" error occurred when the SSH path contained Chinese characters.
  • Minor bug fixes and improvements.

New in Navicat for MySQL 16.0.7 (Jan 3, 2022)

  • Bug-fixes:
  • Unable to show utf8mb4 data.
  • Minor bug fixes and improvements.

New in Navicat for MySQL 16.0.6 (Dec 15, 2021)

  • Bug-fixes:
  • Connection encoding issue in Navicat Cloud.
  • Connection password issue when updating connection in Navicat Cloud.
  • Error occurred when synchronizing to Navicat Cloud.
  • Minor bug fixes and improvements.

New in Navicat for MySQL 16.0.4 (Dec 7, 2021)

  • Bug-fixes:
  • Syntax error occurred when importing data to MySQL table.
  • Notification Email authentication failed in some cases.
  • Minor bug fixes and improvements.

New in Navicat for MySQL 16.0.3 (Nov 23, 2021)

  • Main New Features:
  • New Data Generation Tool
  • Enhanced Charts Feature
  • Support of Navicat On-Prem Server
  • Additional Features:
  • Connection Profiles
  • Field Information Pane
  • Query Execution Summary
  • Navicat On-Prem Server is released
  • Many other new features and improvements

New in Navicat for MySQL 15.0.26 (Jul 28, 2021)

  • Improvements:
  • Support tunneling on PHP 8.
  • Bug-fixes:
  • Unknown Internal Error occurred when importing Excel file in some cases.
  • An empty string was not quoted when exporting to a text file.
  • Query was garbled when the system locale set to Japanese.
  • Export/Import profile did not work if it was copied to Desktop.
  • Minor bug fixes and improvements.

New in Navicat for MySQL 15.0.25 (Apr 27, 2021)

  • Empty rows were added when exporting more than 1.05 M records to Excel file.
  • Error occurred when using Recordset Generator to generate a record set for the Date field.
  • Hanged when designing a table with many fields.
  • Relation lines were disappeared after saving and reopening Logical Model.
  • Minor bug fixes and improvements.

New in Navicat for MySQL 15.0.23 (Mar 15, 2021)

  • Functions were not properly saved as the default value in MariaDB.
  • ER diagram was reloaded when clicking the Design Table button.
  • Unable to toggle "Virtual Type" in an existing table.
  • Error 1227 occurred when creating or designing a table.
  • Minor bug fixes and improvements.

New in Navicat for MySQL 15.0.22 (Jan 13, 2021)

  • Bug-fixes:
  • MySQL/MariaDB connection encoding issue.
  • Wrong MySQL version was detected for Microsoft Azure connection.
  • Minor bug fixes and improvements.

New in Navicat for MySQL 15.0.21 (Dec 15, 2020)

  • Bug-fixes:
  • Queries cannot be displayed when "Settings Location" was set to a network path.
  • Error 80041318 occurred when setting schedule .
  • Minor bug fixes and improvements.

New in Navicat for MySQL 15.0.20 (Dec 8, 2020)

  • Bug-fixes:
  • Flashed in dark mode.
  • "Unallowed argument in list..." error when running export / import schedule.
  • Unable to load version 10 data synchronization profiles.
  • Differences were incorrectly detected in Synchronize to Database.
  • Minor bug fixes and improvements.

New in Navicat for MySQL 15.0.17 (Jun 23, 2020)

  • Differences were detected when re-comparing the model and the database.
  • Unable to synchronize large ndm2 model files to Navicat Cloud.
  • Drop-down list was blank in Table Designer.
  • Unable to scroll after switching the query results to Form view.
  • Wrong SQL generated when adding aggregates using Query Builder in SQL Server.
  • Minor bug fixes and improvements.

New in Navicat for MySQL 15.0.16 (Jun 3, 2020)

  • Improvements:
  • Integer column exported in Number format when exporting Excel file.
  • Display export profiles in the same group of queries.
  • Bug-fixes:
  • Unable to set data to NULL in query results.
  • Crashed when clicking the ellipsis button in Custom Recordset.
  • Pasting data into a column cleared another column data.
  • Default Settings Location path was set to a wrong location for some cases.
  • "Floating point division by zero" error occurred when setting the dashboard background.
  • The file extension was missing when exporting the dashboard.
  • Query Parameter did not work when using a parameter twice.
  • "Invalid floating point operation" error occurred when adding NULL data to the chart.
  • Incorrect columns were displayed after clicking the Default button in the "Choose columns" window
  • Minor bug fixes and improvements.

New in Navicat for MySQL 15.0.14 (May 6, 2020)

  • Bug-fixes:
  • Unable to synchronize data to MySQL 8.0.19.
  • Unable to connect AnalyticDB.
  • Unable to export data to .mdb files.
  • Minor bug fixes and improvements.

New in Navicat for MySQL 15.0.13 (May 5, 2020)

  • Bug-fixes:
  • MySQL table row format reverted to Compact after editing.
  • Syntax error occurred when creating events.
  • Unable to set default value for fields in Table Designer.
  • Unable to show SUPER privilege for MariaDB 10.4 in the user object list.
  • Foreign key was dropped and added when re-comparing the model.
  • Minor bug fixes and improvements.

New in Navicat for MySQL 15.0.12 (Mar 24, 2020)

  • Bug-fixes:
  • Query wrongly returned null results in some cases.
  • Unable to update bit type data.
  • Datetime format issue when exporting to Excel files.
  • Query Results Text pane appended values of the selected cells.
  • Syntax error occurred when renaming an index in MariaDB table.
  • Minor bug fixes and improvements.

New in Navicat for MySQL 15.0.11 (Mar 24, 2020)

  • Bug-fixes:
  • Query wrongly returned null results in some cases.
  • "," was replaced by "." when using Custom Filter in Table Viewer.
  • Minor bug fixes and improvements.

New in Navicat for MySQL 15.0.10 (Feb 19, 2020)

  • Improvements:
  • Added "Table Relation" and "Field Relation" options to Query Builder
  • Added Connection Coloring to Query windows
  • Bug-fixes:
  • Unknown Internal Error occurred when starting Navicat in some cases
  • Crashed when importing two XML files
  • Popup menu was missing when right-clicking on stored procedure results
  • The performance of Privilege Manager was slow
  • Unable to synchronize decimal data from MariaDB to MySQL 80
  • Refresh button in Privilege Manager did not pull the latest privileges
  • Differences were detected after synchronizing model to database
  • Syntax error occurred when saving procedures in some cases
  • Datetime functions generated text in exported Excel files
  • Hanged when searching regular expression in Query Editor
  • Error occurred when transferring computed columns from SQL Server to another SQL Server
  • Minor bug fixes and improvements

New in Navicat for MySQL 15.0.6 (Jan 6, 2020)

  • Improvements:
  • Added shortcuts for "Run Current Statement" and "Select Current Statement" in Query Editor.
  • Bug-fixes:
  • "Unknown Internal Error" occurred when modeling databases.
  • Find bar UI issue in Data Viewer.
  • Unable to print table when using popup menu on Navigation pane.
  • Syntax error occurred when renaming index in MariaDB table.
  • Explain feature did not work with query parameters.
  • Interval type was not supported in Charts.
  • Highlight color issue in Filter wizard when using Dark mode.
  • Minor bug fixes and improvements.

New in Navicat for MySQL 15.0.3 (Nov 26, 2019)

  • Navicat 15 comes with numerous improvements and features to address your database development needs. With over 100 enhancements, Navicat gives you new ways to build, manage, and maintain your databases.
  • Smart Charts:
  • Understand your data better.
  • Our new data visualization tool enables you to transform your data into effective visualizations to identify trends, patterns and outliers. Simplify data analysis and share your workspaces to colleagues for better support your business decisions and strategies.
  • Dashboard:
  • Build an interactive dashboard to display a collection of your charts. Combine multiple views of data to get richer insight. You can also create separate dashboards for different topics that you would like to track.
  • Advanced Charts:
  • Navicat 15 supports 20 chart types. Pick the best-fitting one to ensure your data is clear and accurate presented.
  • Powerful Data Transfer:
  • Send large files to anyone.
  • We are bringing a new experience along with a number of new functions to Data Transfer. Our new design comes with an intuitive interface for customizing the fields and specifying the number of rows you wish to transfer. More importantly, Navicat 15 can robustly and quickly transfers massive amounts of data. So you can accomplish complex transfers faster than ever before.
  • Query Builder:
  • Build your queries faster and visually in new UI.
  • A new approach for SQL writing is released in Navicat 15. Our new SQL Builder embeds an incredibly easy-to-use and an even more intuitive syntax panel for constructing your SQL statement. Navicat 15 not only allow to add subquery to further limit your query results, but also preview the query you are working on and make modification once you locate any syntax errors are made.
  • New Data Modeling Tool:
  • Compare objects before syncing your databases.
  • Navicat 15 introduces a new mechanism for Synchronize to Database function. It provides an easier and more intuitive way to visually compare and identify the differences between model and database. And it shows side-by-side DDL comparison that makes it easy to locate all the object differences. Choose and reorder your synchronization scripts to update the destination database.

New in Navicat for MySQL 12.1.23 (Sep 17, 2019)

  • Bug-fixes:
  • Export process was slow.
  • Unable to dump the default value of TIMESTAMP field.
  • Synchronize to Database feature wrongly detected differences of unique constraints.
  • Minor bug fixes and improvements.

New in Navicat for MySQL 12.1.22 (Aug 1, 2019)

  • Copy and paste data issue in Table Viewer
  • Minor bug fixes and improvements

New in Navicat for MySQL 12.1.21 (Aug 1, 2019)

  • Bug-fixes:
  • Unable to list users for MariaDB 10.4.
  • Code Completion did not work in some cases.
  • Unable to import signed numbers when there was spaces between the sign and the number.
  • Unable to map a source field to multiple target fields in Import Wizard.
  • DELIMITER statements did not work in Console.
  • "Cannot open file" error occurred when scheduling export profiles in some cases.
  • Unable to show empty fields in query result sets.
  • Minor bug fixes and improvements.

New in Navicat for MySQL 12.1.20 (Jun 10, 2019)

  • "syntax error at end of input" error occurred when running CREATE RULE statement in Query Editor
  • "Unknown Internal Error" occurred when opening Table Designer
  • "syntax error at or near "VERBOSE"" occurred when using Vacuum Analyze on PostgreSQL 11 tables
  • Minor bug fixes and improvements

New in Navicat for MySQL 12.1.19 (May 24, 2019)

  • Text editor did not display the full text in some cases.
  • Data Synchronization inserted values into Generated Columns.
  • Minor bug fixes and improvements.

New in Navicat for MySQL 12.1.18 (Apr 17, 2019)

  • Error occurred when connecting to MySQL 40
  • Unable to execute SQL files that contain "NaN" values
  • Primary Key checkbox was deselected when tabbing to the next field in Table Designer
  • "Unknown Internal" error occurred when importing data
  • The DDL of PostgreSQL tables with "tstzrange" data type was incorrect
  • Table Designer cannot show the definition of MySQL 50 triggers
  • Unable to set the precision of "datetime2" data type to 0 in Table Designer
  • The deployment scripts generated incorrect default value in Structure Synchronization
  • "Access Violation" error occurred after editing the data pipeline in Report
  • "Unknown Internal" error occurred when using Automation
  • Minor bug fixes and improvements

New in Navicat for MySQL 12.1.17 (Mar 21, 2019)

  • Bug fixes:
  • Query result pane size did not retain after minimizing the window.
  • Paradox tables cannot be imported.
  • Unknown Internal error occurred when importing data.
  • "On Update Current Timestamp" option did not reflect the settings when using ANSI_QUOTES SQL mode.
  • Column order was incorrect when importing database to model.
  • Minor bug fixes and improvements.

New in Navicat for MySQL 12.1.16 (Feb 26, 2019)

  • "Replace All" button was unable to replace the last occurrence in Query Editor
  • Code completion suggestion list did not show on the same screen as the editor
  • Crashed when opening Oracle table with Spatial data
  • A table was mistakenly transferred even it was not selected
  • Incorrect syntax highlighting issue in Query Editor
  • MySQL trigger definition displayed \ as
  • Unable to transfer unique index from MySQL to SQLite
  • Filter criteria input box was not retained when switching applications
  • Drag and drop selected text on Query Editor did not move the text
  • JSON expression did not display correctly in Table Designer
  • Minor bug fixes and improvements

New in Navicat for MySQL 12.1.12 (Feb 12, 2019)

  • Bug-fixes:
  • SQL order issue in Structure Synchronization.
  • Console window was not colored when connection coloring were set.
  • Minor bug fixes and improvements.

New in Navicat for MySQL 12.1.9 (Nov 23, 2018)

  • Improvements:
  • Added the "Compare owners" option in Structure Synchronization.
  • Bug-fixes:
  • Slow performance when editing users or roles.
  • Floating point numbers were rounded to decimals when import.
  • <html> tag was repeated twice when exporting HTML files.
  • "Add Database to List" button was enabled when the "Use custom database list" option was not checked.

New in Navicat for MySQL 12.1.8 (Oct 5, 2018)

  • Custom Filter was cleared when editing it
  • HTML export did not specify charset
  • "Show/Hide Columns" option was missing in Form View
  • The hidden Information pane was shown when switching from Form View to Grid View
  • Cursor focus issue in Form View
  • Code Completion did not work in some cases
  • Minor bug fixes and improvements

New in Navicat for MySQL 12.1.7 (Sep 10, 2018)

  • Bug-fixes:
  • "SQLite function sqlite_libversion cannot linked" error occurred when starting Navicat.
  • Unable to scroll inside the text box in Form View.
  • "is in list" operator in Filter Wizard did not working correctly.
  • Structure Synchronization compared table options.
  • Minor bug fixes and improvements.

New in Navicat for MySQL 12.1.6 (Aug 21, 2018)

  • Bug-fixes:
  • Unknown Internal Error occurred when showing data "{}" in TEXT editor.
  • Precision value in CURRENT_TIMESTAMP(6) was missing when synchronizing structure.
  • Esc shortcut did not work when error occurred during deleting records.
  • Error occurred when renaming an existing column and adding a new one.
  • Filter value did not displayed when the string exceeded 5880 characters.
  • Unable to display the columns list in Table Designer's Index tab when there was no index.
  • Unable to apply Filter profile.
  • Unable to scroll to right in Filter Wizard.
  • Opening Design Table froze in large database.
  • "Open Table" and "Design Table" were not properly synchronized.
  • Import Target and Field Mapping changed after changing the source file in profile.

New in Navicat for MySQL 12.1.5 (Jul 31, 2018)

  • Improvements:
  • Improved Filter Wizard.
  • Supported expression for default field value in Table Designer.
  • Bug-fixes:
  • Crashed when applying filter in Foreign Key Selection window.
  • Minor bug fixes and improvements.

New in Navicat for MySQL 12.1.4 (Jul 26, 2018)

  • Support Roles for MySQL 8
  • Support Roles for MariaDB 10
  • Brand new Filter Wizard
  • UI and UX Improvement
  • MongoDB is added in Navicat Premium
  • Navicat for MongoDB is released

New in Navicat for MySQL 12.0.28 (May 8, 2018)

  • Bug fixes:
  • 80041318 error occurred when saving a task schedule.
  • The cursor position row moved to the bottom line after saved the procedure/function.
  • Syntax error occurred when updating MySQL user password.
  • Transaction did not end after closing the table in some cases.

New in Navicat for MySQL 12.0.27 (Apr 26, 2018)

  • Unable to transfer objects between different server types by drag-and-drop.
  • Zero decimal place digits were not displayed in Table Viewer.
  • Exported SQL file did not have table name when exporting an unsaved query.
  • Incorrect SQL "ON UPDATE CURRENT_TIMESTAMP(0)" was dumped for MariaDB 5.5 tables.
  • Unknown Internal Error occurred when importing from ODBC.
  • Syntax error occurred when importing CSV files in some cases.
  • Database names were missing in the Drop SQL generated by Structure Synchronization.
  • Unable to change the Tab Width in Query Editor.
  • Unable to edit query results when tables had alias.
  • Procedure parameters were missing in the scripts generated by Structure Synchronization.
  • Unknown Internal Error occurred when Automation ran.
  • Unable to transfer tables with HEX format.
  • Encoding issue of the exported text file.

New in Navicat for MySQL 12.0.26 (Apr 25, 2018)

  • Bug Fixes:
  • "Access Violation" error occurred when creating new connections in fresh installed Navicat.

New in Navicat for MySQL 12.0.25 (Apr 25, 2018)

  • Bug Fixes:
  • Unable to create a query inside a group.
  • The color of function keywords did not change according to the Font Color settings in Options.
  • Column width did not retain after hide and show the column in Table Viewer.
  • Unable to drag and drop a query into a group in some cases.
  • Unable to edit query results in some cases.
  • Unable to disable Foreign Key constraint in Data Synchronization.
  • Crashed when dumping table to sql file in some cases.
  • Foreign Key constraint issue in Import Wizard.
  • SQLite connections was missing in Model's Import from Database feature.
  • Code completion replaced the text after caret.
  • Exported files or reports were not attached to the notification email.
  • Keepalive Interval setting attempted to connect continuously even the database was down.
  • If a query was opened, abnormal behavior happened when closing Navicat.
  • Automation did not start when the computer was logged out.

New in Navicat for MySQL 12.0.24 (Mar 27, 2018)

  • Improvements:
  • Supported Microsoft Azure Database for MySQL.
  • Bug Fixes:
  • Spaces were missing in the SQL exported from Model.
  • Extra newlines were added to the SQL exported from Model.
  • "Hourly" option was missing on Task Schedule's Trigger tab.
  • Wrong datestamp was appended to the exported files.
  • Slow issue when searching in Table Viewer.
  • Unable to move functions into a group.
  • Syntax error occurred when running query in some cases.
  • Unable to select Enum data in query results.
  • Target functions/procedures were not dropped before create when synchronizing structure.
  • Unable to synchronize models/queries in Navicat Cloud.
  • Exported Excel files were corrupted in some cases.
  • "Access is denied" error occurred when setting schedule.

New in Navicat for MySQL 12.0.23 (Feb 22, 2018)

  • Bug Fixes:
  • Error occurred when synchronizing structure in some cases.
  • Replace All did not work in Table Viewer.
  • Cell selection disappeared after pressing CTRL+C in Table Viewer.
  • Error occurred when running query in some cases.
  • "Unknown Internal Error" occurred when exporting query results.

New in Navicat for MySQL 12.0.22 (Feb 22, 2018)

  • Bug Fixes:
  • Unknown Internal error occurred when editing/adding connections.
  • Adding self-referencing table issue in Query Builder.
  • Minor bug fixes and improvements.

New in Navicat for MySQL 12.0.21 (Feb 22, 2018)

  • Bug Fixes:
  • Out of memory issue when running Data Transfer.
  • "Unknown Internal Error" occurred when loading profiles in Structure Synchronization.
  • Export Float data to csv files issue.
  • Syntax error occurred when synchronizing MySQL functions.
  • Crashed when importing Excel or Text files in some cases.
  • Opening large databases in List View took long time.
  • Unable to show query files with ".SQL" extension in Objects tab.
  • Errors occurred when executing MySQL Dump files.
  • CTRL+SPACE shortcut were missing in Query Editor.
  • Print report to PDF command wrongly sent the report to printer.
  • Null date values were exported wrongly as "1900-01-00" in Excel files.
  • Tables Viewer displayed wrong number of digits.
  • Input parameter window did not pop up when exporting query.
  • High CPU usage issue.

New in Navicat for MySQL 12.0.20 (Jan 11, 2018)

  • Unable to transfer POINT data type from MySQL to MariaDB.
  • Minor bug fixes and improvements.

New in Navicat for MySQL 12.0.19 (Dec 1, 2017)

  • Bug Fixes:
  • Unable to zoom in/out Query Editor using mouse wheel.
  • Unable to connect Sphinx servers.
  • Swapping connections did not work when re-comparing in Data Synchronization.
  • Syntax errors occurred when running query in some cases.
  • Unknown Internal error occurred when performing Structure Synchronization.
  • No records was transferred when the target connection was using HTTP Tunnel.
  • Query syntax highlight was wrong after switching tabs.
  • DateTime field Not Null checkbox unchecked wrongly in Table Designer.
  • Unable to export table to xlsx with name longer than 31 characters.
  • Hanged when searching in Table Viewer in some cases.

New in Navicat for MySQL 12.0.18 (Nov 13, 2017)

  • Bug Fixes:
  • The database/schema combo-box did not work in Query.
  • Manual refresh did not work in Server Monitor when auto-refresh was enabled.
  • Unknown Internal Error occurred when performing Structure Synchronization.

New in Navicat for MySQL 12.0.16 (Nov 7, 2017)

  • Bug Fixes:
  • Structure Synchronization detected differences wrongly in some cases.
  • Record delimiter was wrong when exporting to text file using Automation.
  • Table Viewer moved back to the first page when refreshing a table.
  • Characters displayed wrongly in Table Viewer.
  • Unable to select fields when exporting to Excel file.

New in Navicat for MySQL 12.0.15 (Sep 27, 2017)

  • Error occurred when deleting INT field value in Table View

New in Navicat for MySQL 12.0.14 (Sep 26, 2017)

  • Bug Fixes:
  • Wrongly shown differences when synchronizing structure.
  • The DDL tab in Information pane did not updated after saving changes in sub forms.
  • Unknown Internal Error occurred when synchronizing structure/data in some cases.
  • Unable to schedule Data Synchronization profiles.
  • Syntax error occurred when filtering with ' character in Table Viewer.
  • Compared table comments in Structure Synchronization.
  • Input decimal separator issue in Table Viewer.
  • Unable to import date from Excel to VARCHAR field.
  • Query Builder loading was slow.
  • Custom backup file name was ignored when scheduling in Automation.
  • Re-registration issue.
  • Unable to create new table in Import Wizard in some cases.

New in Navicat for MySQL 12.0.13 (Sep 5, 2017)

  • Bug Fixes:
  • Table triggers was not included when backing up tables.
  • Auto increment field was ignored when importing
  • Unable to set the default value of TEXT/BLOB field for MariaDB 10.2.1 or above.
  • Navicat hanged when running a query export profile in some cases.
  • Error occurred when running LOAD DATA LOCAL queries.
  • Special characters were garbled when exporting Access files.
  • Unknown Internal error occurred when exporting Access files.
  • Unknown Internal error occurred when saving changes in Table Designer.
  • "Too many client tasks" error occurred when importing Access files.
  • Double-quote encased text fields were split into new records when importing a record which multiple lines.
  • Syntax error occurred when performing data transfer in some cases.
  • Unknown Internal error occurred when adding multiple records in Table Viewer.
  • Two identical functions declared as different in Structure Synchronization.

New in Navicat for MySQL 12.0.11 (Aug 8, 2017)

  • Bug Fixes:
  • Unable to open Information pane by context menu.
  • Unable to import fixed width text file in some cases.
  • Access Violation error occurred when creating models / tables in some cases.
  • Access Violation error occurred after Navicat was idle.
  • Unable to import the CDATA data in XML files.
  • Number values were exported as text in Excel files.
  • Code completion did not work for alias in SQL Editor.
  • Beautify SQL did not format multiple statements properly in SQL Editor.
  • Unknown Internal error occurred when running query with parameters.
  • Table menu displayed wrong item in some cases.
  • Unknown Internal error occurred when running old version export profiles in Automation.
  • Unknown Internal error occurred when opening tables in some cases.
  • "_Navicat_Temp_Stored_Proc() does not exist" error occurred when saving functions.
  • High memory usage issue in Data Synchronization.
  • "Use empty string as NULL" option did not work in Import Wizard.
  • Unknown Internal error occurred when writing query in some cases.
  • Unknown Internal error occurred when backup in Automation in some cases.
  • Hang issue occurred when launching Import Wizard.
  • Unable to connect with SSL in some cases.

New in Navicat for MySQL 12.0.10 (Jul 14, 2017)

  • Bug Fixes:
  • Error occurred when opening MySQL databases in HTTP connection if enabled "Encode outgoing query with base64" setting.
  • Unable to import Chinese characters from Excel files.
  • Incorrect date and decimal formats in exported Excel files.
  • Filter criteria settings were removed when applying sorting on column.
  • Error occurred when duplicating MySQL tables in HTTP connection.
  • Unknown Internal Error occurred when executing old version export profiles in Batch Job.
  • Save dialog did not pop up when closing backup profiles after editing.
  • Unknown Internal Error occurred when loading Filter profiles in Table Viewer.
  • File path and file name were not saved in Export profiles.
  • Unknown Internal Error occurred when there was multiple statements in Query.
  • Incorrect field names were shown in code completion suggestion list.
  • Unable to attach the report PDF file in notification email.

New in Navicat for MySQL 12.0.9 (Jun 29, 2017)

  • Bug Fixes:
  • "Unknown Internal Error" occurred when typing statement in SQL Editor.
  • Unable to show field names in data pipeline after editing SQL in Report.
  • Beautify SQL formatted the statement wrongly in some cases.
  • Sorting by modified/create date did not work for details view in main window.
  • Connection coloring displayed wrong color in some cases.

New in Navicat for MySQL 12.0.8 (Jun 26, 2017)

  • Wrong table showed when comparing tables in Data Synchronization in some cases.
  • Unable to import special characters from Excel.
  • Unable to paste multiple records in Table Viewer.
  • Created Batch Jobs did not show in Standard Edition.
  • "Unknown Internal Error" occurred when importing files.
  • View Builder locked up when re-open for editing in some cases.

New in Navicat for MySQL 12.0.7 (Jun 17, 2017)

  • Bug Fixes:
  • "Access violation" error occurred when create new query/view.
  • Enum value drop-down list was missing for MariaDB in Table Viewer.
  • Wrongly showed primary key warning in some cases.
  • Unable to type some characters in editor when using international keyboard.
  • Unable to edit connection settings in some cases.
  • Information Pane did not appear in some cases.
  • Internal error occurred when importing CSV files.
  • Cell values froze when scrolling in grid view

New in Navicat for MySQL 12.0.6 (Jun 9, 2017)

  • Bug Fixes:
  • 1142 error occurred when dumping SQL files.
  • 1142 error occurred when backing up databases.
  • Failed to load Data Synchronization profiles.
  • Data display issues in table viewer.
  • Minor bug fixes and improvements.

New in Navicat for MySQL 12.0.5 (Jun 2, 2017)

  • New UI/UX.
  • On Startup: open favorite tabs automatically when Navicat launches.
  • Code Snippet.
  • Advanced Code Completion with better suggestions.
  • Brand new Structure Synchronization: visually show side-by-side DDL comparison between two databases.
  • Brand new Data Synchronization: show particular status to distinguish the differences between records easily.
  • New Automation: easy to find desired profiles and create automated batch jobs.
  • Responsiveness and performance improved.
  • Many other new features and improvements.

New in Navicat for MySQL 11.2.16 (Mar 20, 2017)

  • Bug Fixes:
  • Error occurred when exporting with Time field type.
  • "Argument out of range" occurred when running "Reverse Database to Model".
  • Minor bug fixes and improvements.

New in Navicat for MySQL 11.2.15 (Jan 10, 2017)

  • Bug Fixes:
  • Minor bug fixes and improvements.

New in Navicat for MySQL 11.2.14 (Jan 10, 2017)

  • Bug Fixes:
  • Unable to show some errors in MySQL Console.
  • Crashed when using Query in some cases.
  • Query auto-save feature did not work in some cases.

New in Navicat for MySQL 11.2.13 (Jan 10, 2017)

  • Bug Fixes:
  • Error occurred when getting MySQL query status.
  • Minor bug fixes and improvements.

New in Navicat for MySQL 11.2.12 (Jan 10, 2017)

  • Bug Fixes:
  • MySQL floating point fields were exported to decimal values.
  • Error occurred when profiling query with sql_mode "ONLY_FULL_GROUP_BY" for MySQL 5.7.5 or above.
  • Fixed the sorting issue in Table Viewer.

New in Navicat for MySQL 11.2.11 (Aug 10, 2016)

  • Bug Fixes:
  • Copy and paste issue in Table Viewer's Memo Editor.

New in Navicat for MySQL 11.2.10 (Aug 10, 2016)

  • Improvements:
  • Support inputting tabs in the editor of Table Designer.
  • Support UTF16 formatted files in Execute SQL File and Query's Import SQL functions.
  • Bug Fixes:
  • The media keys (play, pause, next etc) did not work.
  • Unable to connect MariaDB 5.5 with SSL.
  • Failed to transfer data in Chinese locale OS.
  • Foreign keys check SQL was missing at the end of the dumped SQL file.
  • Crashed when synchronizing model to database in some cases.
  • Unable to show the light coloring when the tab is non-active.

New in Navicat for MySQL 11.2.9 (Aug 10, 2016)

  • The datetime field values were inconsistent in exported file.

New in Navicat for MySQL 11.2.8 (Aug 10, 2016)

  • Unable to set "On Update Current_Timestamp" setting in some cases for MySQL version 5.6.5 or above.
  • Unable to add tables to Report's Query Wizard and Query Designer when the table name contained dot.
  • Error occurred when logging in Navicat Cloud if profile path contained Unicode.

New in Navicat for MySQL 11.2.7 (Aug 10, 2016)

  • Fixed multi-monitor with different dpi issue.
  • Column import definition broken when importing.
  • Saved Import profile mapped columns wrongly.
  • "invalid varient operation" error occurred when import from ODBC.
  • "Argument out of range" error occurred when importing CSV file.
  • Primary Key settings were deleted when modifying import profile.

New in Navicat for MySQL 11.2.6 (Aug 10, 2016)

  • Errors occurred when running LOAD DATA LOCAL queries in 64-bit version.
  • Error "Diagram table already exists" occurred when opening some model files.
  • Crashed when exporting connections.
  • "Access violation" error occurred when importing CSV file.

New in Navicat for MySQL 11.2.5 (Aug 10, 2016)

  • "Stop" button was not working in Query.
  • Unable to edit the query in Query Editor when running it.
  • Error occurred when running LOAD DATA LOCAL queries.

New in Navicat for MySQL 11.2.4 (Dec 15, 2015)

  • Bug Fixes:
  • Schedule and Command Line stopped working when user did not sign in Navicat Cloud.
  • Minor bug fixes and improvements.

New in Navicat for MySQL 11.2.3 (Dec 14, 2015)

  • Bug Fixes:
  • "Argument out of range" error occurred when using "Find in Database/Schema".
  • Minor bug fixes and improvements.

New in Navicat for MySQL 11.2.2 (Dec 10, 2015)

  • Major New Features:
  • Navicat Cloud Collaboration
  • Create/Modify/Delete projects.
  • Add members to project for sharing connection settings, queries and models.
  • View Project Activity Log.
  • Data Modeling Tool
  • Support Model Conversion.
  • Support Views.
  • Enhanced Table Designer.
  • Others
  • Enhanced Connection Coloring.
  • Search database object structure.

New in Navicat for MySQL 11.1.13 (Aug 4, 2015)

  • Bug Fixes:
  • Exported result incorrect for TIME field type in Export Wizard.
  • File name with appended timestamp issue in Export Wizard.
  • Slow performance when showing/hiding column with Memo editor opened.
  • SSH protocol error issue.

New in Navicat for MySQL 11.1.12 (May 21, 2015)

  • Bug Fixes:
  • Generated object SQL identifier without escaping quote characters in Model.
  • Unable to load the virtual group settings file created by old versions of Navicat.
  • After sorted a selected column in Table Viewer, access violation occurred when resizing column width.

New in Navicat for MySQL 11.1.11 (Apr 28, 2015)

  • Improvements:
  • Reset the field length to default value after changing the auto guessed field type in Table Designer.
  • Bug Fixes:
  • Access violation error occurred when entering SQL in Query.
  • Cannot access field 'Super_priv' as type Boolean error occurred when managing Users.
  • Unable to download source files with HTTPS connection in Import Wizard.
  • Failed to create/edit users for MySQL 5.7.6.

New in Navicat for MySQL 11.1.10 (Mar 13, 2015)

  • Improvements:
  • Improved the Message Log information.
  • Bug Fixes:
  • Table Designer did not allow to edit MySQL table partition’s Values setting.
  • Unable to identify equality of trigger definitions with different system line breaks in Structure Synchronization.
  • Unable to generate MySQL table SQL with charset binary properly in Structure Synchronization.
  • Code Completion added smart quote wrongly for utc_date() in Query Editor.
  • Unable to convert object names in Data Transfer when using Schedule.
  • Unable to transfer MariaDB triggers in Data Transfer.

New in Navicat for MySQL 11.1.9 (Jan 28, 2015)

  • Bug Fixes:
  • Unable to run in Windows Server 2003.
  • Fixed the color issue in the connection tree.
  • Wrong handling for field type BIT.

New in Navicat for MySQL 11.1.8 (Dec 9, 2014)

  • Improvements:
  • Allow copying field names in Table Viewer and Query's Result.
  • Bug Fixes:
  • "Argument out of range" error occurred after running MySQL/MariaDB queries in Query.
  • Crashed after multiple drag & drop tables in Model Designer.

New in Navicat for MySQL 11.1.7 (Dec 2, 2014)

  • Improvements:
  • Error counting in Data Transfer's Message Log changed from records to records and objects.
  • Bug Fixes:
  • Structure Synchronization was unable to compare the difference between Null and empty default value for MySQL/MariaDB fields.
  • Unable to select new mode in connection tree using Alt+MouseDown.
  • Access Violation error occurred when exporting single column to Word.
  • Duplicated foreign key names issue in Model.
  • Unable to recognize the Row Delimiter when importing from CSV files.
  • Import Wizard was unable to import currency data from DBF files.
  • Advanced settings were saved incorrectly in Data Transfer profiles.

New in Navicat for MySQL 11.1.6 (Sep 19, 2014)

  • Bug Fixes:
  • Synchronized Navicat Cloud model files even they did not have any changes.

New in Navicat for MySQL 11.1.5 (Sep 17, 2014)

  • Improvements:
  • Added Open Containing Folder feature for Query, Report, Backup and Model.
  • Added Open with External Editor feature for Query.
  • Added press and hold Alt key and double-click table to open Table Design.
  • Bug Fixes:
  • Failed to dump SQL file from Navicat Cloud connection.
  • Unable to select foreign key for new table in Table Design.

New in Navicat for MySQL 11.1.3 (Aug 26, 2014)

  • New Features:
  • Support to sync selected conntection settings, queries, model files and virtual group information to Navicat Cloud. For more information, please visit here.
  • Improvements:
  • Support parameter in Report command line.

New in Navicat for MySQL 11.0.18 (Aug 6, 2014)

  • Improvement:
  • Query profile now support to show in server level.
  • Bug Fixes:
  • Unable to save local file if database name contained heading/tailing space.
  • Crashed when loading and parsing a long incorrect syntax SQL in Query.
  • After adding a new row, pressing next/last button would freeze the Form View in Table Viewer.
  • Number of rows selected incorrectly when using shift+up/down keys in Table Viewer.
  • Multiple selection not working properly with shift+keys in Table Viewer.
  • When using CTRL+A to select text inside a data cell, all cells were incorrectly selected in Table Viewer.
  • Import Paradox not able to import data properly in Navicat 64bits.
  • Backup not able to backup table with foreign key.
  • Wrong NullsOrder setting was shown for foreign key fields under Table Designer in Data Modeling Tool.
  • Wrong CREATE TABLE SQL with character set and comment exported under Export SQL in Data Modeling Tool.

New in Navicat for MySQL 11.0.17 (Mar 3, 2014)

  • Improvement:
  • Table Viewer is now able to update a row even not all the keys are input for numeric columns.
  • Always import as NULL value if "Use empty string as NULL" option is checked in Import Wizard.
  • All records are now able to show under the Fixed Width window in step 3 of Import Wizard.
  • Bug Fixes:
  • 'Control 'Dock2Form_1' has no parent window' error occured while docking in and out of windows.
  • Connection was deleted after renamed to capitalized name.
  • Foreign key information with two words identifier not able to get correct correctly in Table Designer.
  • Foreign key information with NDB cluster storage engine not able to get correctly in Table Designer.
  • Parameter list not able to show in Function Designer when there was CHARACTER type in function parameters.
  • 'Table does not exist' error occured while opening an export profile.
  • Server with unsaved password not able to connect under 'Import from Database' in Data Modeling Tool.

New in Navicat for MySQL 11.0.16 (Jan 9, 2014)

  • Improvements:
  • Added Dynamic Column Editor for MariaDB in Table Viewer.
  • Bug Fixes:
  • Lose focus in Table Viewer.
  • Function parser error.
  • Access Violation error occurred when designing MariaDB tables with foreign keys.
  • Access Violation error occurred when importing invalid connections.
  • ERegistry Exception error occurred when starting Navicat.
  • Wrong Date Editor frame size in Table Viewer.
  • Stack Overflow error when running Query.
  • Data Synchronization failed when MySQL or MariaDB table has multi-fields Primary Key.
  • Permissions issue of the Updater.
  • Cursor was missing in Stored Procedure.
  • Failed to create MySQL user with special characters password.

New in Navicat for MySQL 11.0.12 (Nov 18, 2013)

  • Bug Fixes:
  • Wong handling on Integer type.
  • Changed properties not check properly in Table Designer.

New in Navicat for MySQL 11.0.11 (Nov 11, 2013)

  • Bug Fixes:
  • Missed to mark quotation on keywords in Query Builder.
  • Process was unable to stop while running query in Essentials version.
  • Failed to include auto increment column setting for floating point data types.
  • Access Violation occured when executing query clause with 'GROUP BY _xxx, _yyy'.

New in Navicat for MySQL 11.0.10 (Sep 11, 2013)

  • Bug Fixes:
  • Failed to show definition/DDL for View.
  • Failed to check/uncheck column fields in Show/Hide Columns using space key in Tabler Viewer.
  • Failed to scroll horizontally for wide content after applying Filter Wizard in Table Viewer.

New in Navicat for MySQL 11.0.9 (Aug 7, 2013)

  • Bug Fixes:
  • Access violation occured in 64-bit scintilla (Text Editor) after Navicat used huge memory (>4G).
  • Access violation occured while copying and pasting field in Table Designer.
  • No respond from Filter Wizard in Table Viewer after execution error of filter query.
  • Failed to replace text with an empty string using the Find and Replace feature.
  • Fixed the scrolling issue in docking window on secondary display.
  • Failed to display unicode user name and organization in Navicat About box.

New in Navicat for MySQL 11.0.8 (Aug 7, 2013)

  • Bug Fixes:
  • Default value could not be kept longer than 255 characters in Table Designer.
  • Column width not able to be reset after showing the hidden column in Table Viewer.
  • Access violation occured in Table Viewer while reconnecting SSH connection with another port.
  • Query message in status bar not updated if no result return after Run.
  • Fixed concat string (with date) in Query.
  • Access violation occured when entering query clause with 'GROUP BY _xxx, _yyy'.

New in Navicat for MySQL 11.0.7 (Jul 3, 2013)

  • Key was rejected for SSH connection.
  • Access violation occured while running report in command line.
  • Losing searched position in Memo editor after first searching or clicked into the Memo editor.
  • Fixed query parser error.
  • Invalid relation cardinality not showed in red color in Data Modeling Tool.

New in Navicat for MySQL 11.0.6 (May 13, 2013)

  • Fixed "Keyboard Interactive Failed" error for SSH tunnel connection.
  • Crashed while using SSH tunnel connection for both source and target servers in Data Transfer.
  • "Access violation" error occurred while entering query clause with 'ORDER BY _xxx ASC/DESC' in Query.
  • Notification email not sent with an unsaved batch job.

New in Navicat for MySQL 11.0.5 (Apr 30, 2013)

  • Native 64-bit version
  • Interface:
  • New User Interface
  • Aero Snap with new docking system
  • Connection:
  • New SSH Manager
  • Connection Tree Filter
  • Table Viewer:
  • Find and Replace data
  • Box Selection
  • Multi-Cell Editing
  • Search Columns
  • Web Viewer
  • Memo Editor with syntax highlight
  • Support Transaction
  • Support animated GIF in Image viewer
  • Copy data as INSERT/UPDATE statement
  • Table Designer:
  • Search Columns
  • Field Type Prediction
  • Query:
  • Enhanced Query Builder
  • Import Wizard/Export Wizard:
  • JSON file
  • CSV file
  • Improved binary data handling
  • Report:
  • Enhanced PDF printing
  • Others:
  • New Registration and Activation System
  • New Updater

New in Navicat for MySQL 10.1.8 (Feb 4, 2013)

  • Improvement:
  • Navicat is now able to delete tables which contian Foreign Key constraints without warning messages.
  • Bug Fixes:
  • "Access violation" error occurred while applying an existing table name on a new table in Data Modeling Tool.

New in Navicat for MySQL 10.1.7 (Dec 11, 2012)

  • Improvement:
  • Support fractional seconds precision of time, datetime, timestamp data types for MySQL 5.6.4/MySQL MariaDB 5.3 or above.
  • The Profile tab under Query is now displayed without sorting.
  • Support date time format 2012-12-31T01:02:03.456 in Import Wizard.
  • Support fractional seconds precision of time, datetime, timestamp data types for MySQL 5.6.4 or above under Synchronize to Database function in Data Modeling Tool.
  • Support to ignore comparing DEFINER clause of view, event, trigger, procedure and function in Structure Synchronization.
  • Bug Fixes:
  • Create function statement which was after DELIMITER change statement was unable to be executed in Query.
  • "List index out of bounds" error occurred when some source fields were removed after import profile were created during Import Wizard.
  • Binary data from Access/ODBC was imported incorrectly during Import Wizard.
  • Synchronize to Database function in Data Modeling Tool genarated incorrect comparison result for equivalent source and target foreign keys.
  • Records were unable to generate for Federated table in Dump SQL File and Data Transfer.

New in Navicat for MySQL 10.1.6 (Sep 24, 2012)

  • Improvement:
  • Added data format options for XML file in Export Wizard.
  • Bug Fixes:
  • Wrong time unit (ms) was shown under Messages tab in Query function.
  • Table Designer in Data Modeling Tool was unable to save newly added index and foreign key.
  • Synchronize to Database function in Data Modeling Tool was unable to generate the referencing table schema name in the SQL scripts.

New in Navicat for MySQL 10.1.5 (Aug 23, 2012)

  • Bug Fixes:
  • Empty named relation was unable to load back in Data Modeling Tool.
  • Unable to generate sync queries for fields with auto increment and primary key in Data Modeling Tool.
  • "Access violation" error occurred while opening "Import from Database" form in Data Modeling Tool.

New in Navicat for MySQL 10.1.3 (Jul 27, 2012)

  • Bug Fixes:
  • Minimized docked window could not restore normally.

New in Navicat for MySQL 10.1.2 (Jul 19, 2012)

  • Improvement:
  • Added font selection in Option for ER Diagram.
  • Bug Fixes:
  • 1064 error occured when running Store Procedure.

New in Navicat for MySQL 10.1.1 (Jul 19, 2012)

  • If the table contained many columns, new column would be inserted to wrong position in Table Designer (Data Modeling Tool).

New in Navicat for MySQL 10.1.0 (Jun 15, 2012)

  • Improvements on Data Modeling Tool:
  • Build model with multiple schemas.
  • New wizard "Import from Database".
  • New wizard "Synchronize to Database".
  • Search filter.
  • Align/Distribute diagram objects.

New in Navicat for MySQL 10.0.11 (Mar 30, 2012)

  • Bug Fixes:
  • Data truncated when exporting pdf file from Report Builder.
  • Navicat got hanged while performing a search in Table Viewer.
  • Incorrect excel file format was exported while having data started with 0 in Export Wizard.
  • Execute SQL File function would not run if there was an identifier contains "GO" characters.
  • "double" data type was not being handled properly in Export Wizard.

New in Navicat for MySQL 10.0.10 (Mar 30, 2012)

  • Improvement:
  • Import speed has been improved in Import Wizard.
  • Export speed has been improved in Export Wizard.
  • Bug Fixes:
  • Navicat generated 'Not Implemented' error when running under replacement shell UI.

New in Navicat for MySQL 10.0.9 (Mar 30, 2012)

  • Bug Fixes:
  • While scrolling index fields, the scrolled position could not be reflected in Table Designer.
  • Table Designer generated incorrect SQL statement in field ordering.
  • The comparison in columns ordering were generated incorrectly in Structure Synchronization, and Synchronize to Database in Modeler.
  • Extra SET FOREIGN_KEY_CHECKS queries were generated even if the comparison results were identical in Structure Synchronization.
  • Crash occurred when closing Synchronize to Database in Modeler during the comparison in progress.
  • Crash occurred while renaming table failed with server error in ER-diagram view.
  • Data Transfer would hang in Navicat Scheduler.

New in Navicat for MySQL 10.0.8 (Jan 4, 2012)

  • Improvement:
  • Enhanced Model transformation.
  • Bug Fixes:
  • "Access violation" error occurred when dragging n dropping a server node in connection tree together with the Model/Schedule object pane were opened.
  • When created a virtual group in the connection tree, it would be added under Model/Schedule object pane while they were opened.

New in Navicat for MySQL 10.0.7 (Jan 4, 2012)

  • Improvement:
  • Source field order is now kept in target table after running "Synchronize to Database".
  • Bug Fixes:
  • Incorrect field type showed in ER Diagram.
  • Fixed-width and row delimiter were unable to retrieve from a profile in Import Wizard.
  • Print report to PDF file would generate a blank file.
  • Non-latin characters with different collation columns were unable to search in "Find in Database" feature.

New in Navicat for MySQL 10.0.6 (Nov 14, 2011)

  • Improvement:
  • Support column comment up to 1024 characters for MySQL 5.5.3.
  • Support table comment up to 2048 characters for MySQL 5.5.3.
  • Bug Fixes:
  • Data Modeling Tool was unable to set the reference field of foreign key.
  • Data Modeling Tool was unable to print with landscape page setting.
  • When importing data from an URL, it failed to create a temporary file if the same temporary file was being accessed.
  • Tables contained geometric point data was failed in Data Transfer and Data Synchronization.
  • Restore didn't work with the .pmb file created from Navicat version 5.
  • Connection Information could not display properly in large font size.
  • Default value of bit field was shown incorrectly in Table Viewer.

New in Navicat for MySQL 10.0.5 (Nov 14, 2011)

  • Improvements:
  • Improved performance of "Reverse Database to Model" and "Reverse Tables to Model.
  • Foreign Keys is now able to be imported into Model.
  • Spacing issue has been improved in Beautify SQL.
  • Bug Fixes:
  • Import from paradox file was unable to get signed short integer values.
  • User Privileges typo was fixed.

New in Navicat for MySQL 10.0.3 (Sep 12, 2011)

  • Major New Features:
  • Data Modeling Tools.
  • ER Diagram view.
  • SQL Minifier.
  • Database Wide Search.
  • Improvements:
  • Ability to run transaction backup for MySQL database (InnoDB only).
  • Added object list in Query Editor.
  • Added DDL tab in Object Information.

New in Navicat for MySQL 9.1.11 (Jun 29, 2011)

  • Improvements:
  • Added Ctrl+a as shortcut key for "select all" in Form View.
  • Bug Fixes:
  • Wrong table would be copied while running "Duplicate Table" function.
  • Object Information was unable to be refreshed when under "List" view mode.
  • Foreign Key Check box under Table Designer was unable to be toggled using space bar.
  • Searching in Table Viewer would freeze when no record showed on the existing view.

New in Navicat for MySQL 9.1.10 (Jun 29, 2011)

  • Bug Fixes:
  • Scroll bar in Trigger Definition editor was missing.
  • Object List frozen.
  • The size of the width in Run Result columns were too large in Stored Procedure form.
  • "Grid index out of range" error occured while refreshing in Table Viewer.
  • Connection combo box showed wrongly in Data Synchronization.
  • Query was unable to execute a SQL containing DROP statement inside Create Statement.

New in Navicat for MySQL 9.1.9 (Jun 29, 2011)

  • Improvements:
  • Added "Grant All", "Revoke All" etc in Server Privileges tab of User Designer.
  • Bug Fixes:
  • Imported text-based file with UTF-8 encoded data to blob field incorrectly.
  • "Use empty string as NULL" option while importing from XLS/XLSX formats is now working correctly.
  • Procedure/Function Designer was unable to get the body part correctly.
  • Failed to run multiple Data Synchronization at the same time.
  • Table with identity fields was not working correctly in Data Synchronization.
  • Invalid pointer error would occur after editing procedure/function during Structure Synchronization.

New in Navicat for MySQL 9.1.8 (Jun 29, 2011)

  • Improvements:
  • Improved sorting order in Connection Tree and Object list.
  • Bug Fixes:
  • Table Designer was unable to handle field insertion.
  • Table Designer was unable to insert a field as first since Navicat modifies the second field to reference the not yet inserted field.
  • Table Designer now supports primary key fields ordering.
  • Table Designer was unable to show/edit trigger definition.

New in Navicat for MySQL 9.1.7 (Jun 29, 2011)

  • Improvements:
  • Improved the compatibility of third party plugin (eg. Ultramon, Hardcopy etc).
  • Bug Fixes:
  • Multiple files with files delimited as '|' were unable to be recognized during Import Wizard.
  • Function Designer was unable to show definition for function with certain return types.

New in Navicat for MySQL 9.1.6 (Jun 29, 2011)

  • Tree node was unable to be highlighted when Connection Coloring feature was applied under Windows XP.
  • DBF character field length would be set to 254 if table field length is 0 while exporting to DBF file.

New in Navicat for MySQL 9.1.5 (Jun 29, 2011)

  • Function/Procedure Designer was unable to show object body contents with RETURNS text as CHARSET and RETURNS ENUM/SET data type.
  • Function/Procedure Designer was unable to show object body contents with argument of ENUM/SET data type.
  • Query Builder was unable to recognize identifier starting with numbers, e.g. 123xyz.
  • Wrong parenthesis generation in Query Builder when new table was added to FROM clause of query like e.g. select ... from (t1 join t2 on a=b).
  • Code Completion did not work properly with field name if tables were from different database.
  • Exported data (string) to Excel file did not work properly, e.g. value of '1E' would being exported as 1.

New in Navicat for MySQL 9.1.3 (Jun 29, 2011)

  • Data was truncated with VARCHAR as data type.

New in Navicat for MySQL 9.1.2 (Jun 29, 2011)

  • Support of MySQL Server 5.5.
  • Support of geometry data type.
  • Support BTREE and HASH index methods.
  • New Privilege Manager.
  • Enhanced User Management.
  • Data Synchronization performance improved with new engine.
  • Connection Coloring.

New in Navicat for MySQL 9.0.15 (Jun 29, 2011)

  • "700 - Invalid response: 403" error occured when using HTTP tunnel connection.
  • "Out of memory" error occured when running a long SQL in Query function.
  • "Access violation" error occurred when running an invalid SQL syntax in Query function e.g. SELECT DBMS_OBFUSCATION_TOOLKIT.MD5(input_string=>'1') FROM DUAL.
  • Result form showed in Query Editor would be closed after a new query was run.
  • Beautify SQL returned an invalid SQL syntax, e.g. formatted xxx@yyy into xxx @ yyy.
  • "Cannot call Start on a running or suspended thread" error occured when exporting tables with mutli resultsets.

New in Navicat for MySQL 9.0.14 (Oct 5, 2010)

  • Bug Fixes:
  • When pasting an enum type value using CTRL+V in Tabler Viewer, the drop down list box would be shown in wrong position.
  • "Access violation" error occurred when running an invalid SQL syntax in Query Builder, e.g. select ... from ,table01.
  • Imported string data as blob data incorrectly to database using Import Wizard.
  • In Structure Synchronization, when the queries generated in the "Queries for Modification" list were too long (e.g. 8000 characters), the whole line would become blank.
  • Field names for some tables with special names were unable to be listed in Report Builder.

New in Navicat for MySQL 9.0.13 (Sep 15, 2010)

  • Improvements:
  • Horizontal scrollbar is now reset to the left position after applying Beautify SQL feature.
  • Bug Fixes:
  • "Access violation" error sometimes occurred when running an invalid SQL syntax in Query Editor.
  • "Access violation" error occurred when running union/join/inner query in Query Editor.

New in Navicat for MySQL 9.0.12 (Aug 31, 2010)

  • Brackets in FROM clause could not be parsed between Query Editor and Query Builder.
  • When exporting numeric data with comma as decimal seperator to access file, the numbers were displayed without the comma.
  • When exporting numeric data to excel file, it would be exported as string type.
  • Sort by time could not work properly in Server Monitor.
  • Process ID became negative value in Server Monitor.

New in Navicat for MySQL 9.0.10 (Jun 28, 2010)

  • Improvements:
  • Structure Synchronization will now not compare MySQL table comment.
  • Bug Fixes:
  • Auto-reconnection did not work on SSH tunnel connection to MySQL server.
  • Fixed the unicode display problem on Text field with MySQL 4.0 or below.
  • Beautify SQL would cause error if extra spaces existed in aggregate function.
  • Fixed error when importig XML files from the Interent.
  • When exported data to Excel spreadsheet, string start with zero (e.g. 009123) would be changed to integer (9123).
  • "Access Violation" error occured in Manage User when MySQL user did not have enough privilege.
  • "Ask to save new queries" in Options would be reset to unchecked after Navicat restarted.

New in Navicat for MySQL 9.0.9 (Jun 8, 2010)

  • "700 - Invalid response: 417" error occured when connecting to server over HTTP Tunnel.
  • "Duplicate name 'Field11' in TFieldDefs" error occured if a table contained more than 11 fields in which the first ten field names include "Field1".
  • Tab order in Import Wizard was set up incorrectly.

New in Navicat for MySQL 9.0.7 (May 22, 2010)

  • Improved virtual grouping rename issue - e.ggroup like "ITem" and it didn't allow to change into "Item".
  • Changed to use Ctrl+MouseWheel instead of LeftClick+MouseWheel for zoom in/out function in Query Editor.
  • Query Builder is now able to handle incomplete SQL statement when switching between Query Editor and Query Builder.
  • SELECT clause is now able to be generated when dragging a table to Query Builder without selecting any columns, and switching to Query Editor.
  • Improved export data to excel spreadsheet - number/float data is now being export to number format instead of string format.
  • Widen the width of the saved profiles list under Data Transfer and Data/Structure Synchronization windows.
  • Added shortcuts for Structure Synchronization - [ctrl+a] to select all scripts, [ctrl+c] to copy selected scripts, right click the popup menu to copy the selected scripts.
  • Bug Fixes:
  • Access Violation error occured when exporting chart report to excel file.
  • "1054 unknown column error" occured when updating or inserting a record in MySQL View that has Alias names in the Select statement.
  • The automatic word wrap in TEXT fields not working properly in Form View.
  • "Navicat is not able to prase SQL" error occured in Query Editor.
  • Navicat freezed when applying "Beautify SQL" on some SQL statements.

New in Navicat for MySQL 9.0.6 (May 12, 2010)

  • Bug Fixes:
  • When unchecked MySQL "Include other table options" in Data Transfer, engine/table type, character set, auto increment settings were not transferred properly.
  • The font size used in Query grid was smaller than in View grid.
  • "Set Display Format" option in Table Viewer did not work in numerical field.
  • Fixed the wrong positioning issue of main menu items.
  • MySQL character set/collation type issue in Query Builder or View Builder.

New in Navicat for MySQL 9.0.5 (May 12, 2010)

  • Improvements:
  • Improved the performance for opening Table Viewer with huge amount of columns.
  • Bug Fixes:
  • When selecting a particular entry in an enum select box by typing the first letters of the item, the wrong value would be saved if confirmed the changes using the check mark.
  • When applied "Auto save" function, recover window would not launched if multiple Navicat instances started.
  • "Access violation" error occured when creating function using Function wizard.
  • "Not enough storage is available to complete this operation" error occured when exporting field values start with "=" to Excel file.
  • Fixed the drag & drop problem on Select, Where, Group By, Having, Order By, Limit regions in Query Builder.
  • When trying to determine if the dataset were editable in Query, error would occur if user contained privilege on View, but did not have select privilege for Table.
  • Error would occur when switching between Query Editor and Query Builder with MySQL INTERVAL clause included.
  • "Access violation" error occured for code/word completion feature.

New in Navicat for MySQL 9.0.4 (May 12, 2010)

  • Improvements:
  • Better handle case sensitive of object identifier for Query Builder.
  • Support "select ... from ... group by left(..., ...)" when switching from Query Editor to Query Builder.
  • Improved keywords list for Code/Word Completion.
  • Attached hot keys to the navigation bar in Table Viewer.
  • Bug Fixes:
  • Toolbar buttons did not refresh after maximized/minimized and changed size of panes.
  • Toolbar would blink when toggling taskbar auto hide option.
  • Incompleted Stored Procedure SQL statement showed in Stored Procedure Designer.
  • When sweithed between Query Builder ad Query Editor, ";" would be inserted into the middle of the statement.
  • Auto-increment and character set would not be transtered during Data Transfer function.
  • "Select All" and "UnSelect All" buttons missing in Data Synchronization window.

New in Navicat for MySQL 9.0.3 (Apr 26, 2010)

  • Import/Export connection.
  • Significant Improvements made in code/word completion.
  • Code Folding.
  • Matched Brace/Bracket Highlighting.
  • Parameter Tips.
  • Zoom In/Out for SQL editors.
  • SQL Beautifier.
  • Favorites.
  • Object Filter.
  • Individual database objects backup.
  • Unicode Character Report.
  • Auto save in Query, Function etc.
  • Custom sort in Tabler Viewer.
  • Significant Improvements made in editor and data grid searching.
  • Notification email supports SSL/TLS in Schedule.
  • History Log Viewer.

New in Navicat for MySQL 8.2.20 (Mar 1, 2010)

  • Improvements:
  • In Table Viewer, MySQL Limit clause will now exclude from the Update/Delete statement if primary key does not exist.
  • Bug Fixes:
  • Collations could not be changed for MySQL 4.1.
  • When altered MySQL View definer, wrong quoting applied.
  • Word Wrap status did not save in the Query Editor.
  • "Access violation" error occured when adding "Order By" or selecting any fields after "Select * from table" being run several times in Query Builder.
  • When import from ODBC with empty tables, "BOF/EOF access" error would occur.
  • Error dialog occured when selecting target connection in Data Transfer.

New in Navicat for MySQL 8.2.19 (Jan 19, 2010)

  • Bug Fixes:
  • Restore function could not work properly.
  • Insert Field did not work in Table Designer.

New in Navicat for MySQL 8.2.18 (Jan 14, 2010)

  • Improvements:
  • If length does not specify for MySQL char/varchar, 255 value will now be assigned when saving a table.
  • Bug Fixes:
  • When using MySQL HTTP Tunnel connection and user tried to add/duplicate an user. After pressing OK to close the user form, Navicat would sometimes causes "Access Violation" error.
  • When altered a MySQL data type that contains unsigned/zerofill properties into BIT type, table could not be saved in Table Designer.
  • BIT type default value could not be handled properly in some MySQL server.
  • "1055" errod occured when running MySQL queries after the SQL mode was set into 'TRADITIONAL,ONLY_FULL_GROUP_BY,NO_AUTO_VALUE_ON_ZERO'.
  • "1045 - Access denied" error occured when a target server was not selected during MySQL Data Transfer.
  • Events and Sequences could not shown under Object Selection tab in Restore form.

New in Navicat for MySQL 8.2.17 (Nov 24, 2009)

  • Improvements:
  • In step 6 of Import Wizard, Source field name would be truncated if longer than 255 characters. Now, Navicat supports up to 5000 field name characters.
  • Bug Fixes:
  • MySQL Auto increment value could not be altered if "Use DDL from SHOW CREATE TABLE" option was disabled with "Include Auto Increment" option being checked in Data Transfer.
  • Refresh did not work for getting update data.
  • When import text-based file using Import Wizard, Navicat was unable to get the number of columns correctly if the file did not contain field name row or there were empty lines existed before first data row.

New in Navicat for MySQL 8.2.16 (Nov 18, 2009)

  • Bug Fixes:
  • The cursor position moved to end-of-line after saved the Stored Procesure/Function.
  • "Access Violation" error occured when getting the Event information from Linux server.
  • Failed to establish SSH connection when the private key path contained unicode.
  • when the server name contain unicode characters, this server name was unreadable in SQL file which created using Data Transfer feature.
  • "Control 'ppParameterEditor' has no parent window" error occured when clicked on the ParametersEditor button which under Generation topic in Report Builder.
  • When a table contained some long field names, those field names were only partialy visible or even invisible in Form View.
  • When resizing the Data Transfer/Data Synchronization/Structure Synchronization window, all data fields expanded to display longer content except the "profile" drop down list.

New in Navicat for MySQL 8.2.15 (Nov 18, 2009)

  • "Truncate Table" function did not work with multiple tables if using HTTP Tunnel connection.

New in Navicat for MySQL 8.2.14 (Nov 18, 2009)

  • Improvements:
  • "Exceed package size..." error will now occur to remind you to enlarge the max_allowed_packet variable if the records larger than the maximum packet size setting when running Data Synchronisation for MySQl server.
  • Report Builder now accepts datetime function for MySQL server.
  • Bug Fixes:
  • "Property cannot be found" error occured when importing Access file with datatype that may involve decimal places info, e.g.currecy, number, floating point value.
  • BLOB data in text file was unable to import successfully.
  • When added a new field (without labelling its name) in MySQL server usng Table Designer, then click the Move Up button. The last field in the table would be disappeared.
  • "List index out of bound" error occured when using an account, which did not have enough privileges, to open MySQL Stored Procedure/Function.
  • "Access Violation" error occured when exporting data to Access file if using HTTP Tunnel connection.

New in Navicat for MySQL 8.2.13 (Sep 4, 2009)

  • Improvements:
  • Support specify the socket name in Connection for MySQL server.
  • Improve suggestion on target data type and provide a default precision and scale information in Import Wizard.
  • Support export to clipboard.
  • Bug Fixes:
  • When docking a console window to main window, the wheel of mouse would be no effect.
  • Month calendar Could not fully display in some system.
  • If password did not save in Connection Properties, Dump SQL File would not work propertly.

New in Navicat for MySQL 8.2.12 (Sep 4, 2009)

  • Improvements:
  • Support specify the socket name in Connection for MySQL server.
  • Improve suggestion on target data type and provide a default precision and scale information in Import Wizard.
  • Support export to clipboard.
  • Bug Fixes:
  • When docking a console window to main window, the wheel of mouse would be no effect.
  • Month calendar Could not fully display in some system.
  • If password did not save in Connection Properties, Dump SQL File would not work propertly.