0

I am constantly facing this issue when importing .csv files into the database. I am getting the following error:

Unhandled exception: 'ascii' codec can't decode byte 0xc3 in position 1022: ordinal not in range(128)

Check the log for more details.

In the beginning, it was enough to change the encoding with CotEditor to Unicode (UTF-8) as I am operating on Mac, however, lately, the only way how to fix it is to send the document to a laptop operating on Windows, open it in Excel there and send it back to my Mac. Then it will upload without any issues (at least it worked so far).

I am sure, this has to be some issue on my laptop but from what I found as solutions seems like I have everything set well in the database and in the correct encoding format.

Is there anyone facing the same issue who was able to fix it for good so I don't have to send the document between different computer operational systems?

Changing encoding to UTF-8.

Improve this question
4
  • Have you tried converting it in "Unicode (UTF-8) with BOM" with CotEditor? Commented May 11, 2023 at 1:52
  • Something is set to ascii instead of utf8. Commented May 11, 2023 at 19:09
  • If it is a BOM, then you have a worse problem Double encoding Commented May 11, 2023 at 19:11
  • Download old Workbench version 8.0.21 and the problem will be gone. Not sure why this isn't fixed... Commented Oct 26, 2023 at 13:40

1 Answer 1

Reset to default
5

I make sure my csv file is utf-8, but I still get the error, finally, I open mysql-workbench in terminal and solve it.

to run MySql Workbench from the command line open /Applications/MySQLWorkbench.app

Improve this answer
Sign up to request clarification or add additional context in comments.

3 Comments

nice! it worked for me too. if someone would like more in this here is a link: dev.mysql.com/doc/workbench/en/wb-launching-macos.html
After hours of dealing with weird bugs, this is what solved them.
wow, it's weird! however, it saved me! Thanks for sharing!

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.