![]() The fact this solution appears to still work in 2020 just confuses me even more. When you read the Wikipedia article on Mac OS Roman encoding it confuses you even more, because roman encoding is actually an old style of encoding used. I got lucky I got to Western (Mac OS Roman) before giving up on solving the issue. The database dump would not import and I got desperate, going down the list of different encoding formats until it worked. This fix actually came out of frustration. When importing your database dump, you need to select Western (Mac OS Roman) as the encoding format for the file to import without issue.Īs for why this fixes the issue, I wish I could give you a great story about deep-diving into the technical aspects of how character encoding works, but alas, I can’t. It seems MySQL databases exported from a Linux environment (in my case it’s Amazon Linux) and then imported into Sequel Pro on Mac results in a weird encoding mismatch. The database dump file I am pretty sure was UTF-8 and it seems autodetect failed to address the issue, then I got digging and worked out the problem. I encountered an issue where the database dump would get half way through the importing process and then error out about the encoding being incorrect. The size of the database dump file was almost 400mb (it’s a big database). sql file that I dumped via the command line on a remote server. See LICENSE for complete details.Now that I use a Mac for work I use Sequel Pro for administering databases (at home I use Navicat, but can’t warrant the expense for work paying for a Mac licence). Sequel Ace is free and open-source software licensed under MIT. All rights reserved.įorked from Sequel Pro: Copyright (c) 2002-2019 Sequel Pro & CocoaMySQL Teams. Sequel Pro is an open-source and 100 free database management application to work with MySQL & MariaDB databases on MacOS. Beta releases also have increased logging turned on to help us identify critical issues.Ĭopyright (c) 2020-2022 Moballo, LLC. The downloadable app in a beta/ tag has a different name and identifier (Sequel Ace Beta), meaning you can install it side-by-side with the latest App Store release. Operating System: OS X 10.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |