I used navicat to dump the database and the file it generated was utf-8. In order to preserve non-ascii characters when transferring data from a mysql database encoded with latin1 to another mysql database:ġ) make sure that the target database is set with a default encoding of utf8ĪLTER DATABASE db_name DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci Ģ) export the database encoded as utf-8. Here’s a checklist I saved for future-me last time I had to deal with it: Other enhancements include the compatibility with any MySQL server version up to 5.1.X, Incremental Search in Table View, usability enhancement in Table Design and many other improvements on features and user-friendliness.Have you checked to make sure that the DB and the DB tables are all set to utf8_general_ci collation? I’ve seen it where the tables are utf8 but the database itself is latin1 and all hell breaks loose. Email can also be sent to notify the users upon the completion of the scheduled task. Enhanced Report Printing feature allows user to print report to PDF, HTML and more. In addition, users can now open profile on their desktop directly with the new Profile System. A significant change has also been made to the Form View, which now shows a clearer display of fieldname and its value with focus on current record.Ĭode Completion is introduced to this new version of Navicat which makes SQL scripting faster than before. Navicat v.8.0.28 also allows Virtual Grouping which provides better categorization for objects. This new version supports MySQL 5.1 new feature Scheduled Event, enabling users to set a schedule for any Event defined in MySQL. PremiumSoft CyberTech Limited today announced the immediate availability of Navicat for MySQL v.8.0.28.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |