'MySQL Run SQL Script Error says "'ascii' codec can't decode byte 0xe2 in position 2386: ordinal not in range(128)"

My setup:

  • late 2018 MacBook Air
  • macOS Big Sur 11.5.2
  • MySQL 8.0.26 Community Edition

I am trying to run an SQL file I downloaded by doing File > Run SQL Script. But when I open that .sql file, I get an error message saying this:

'ascii' codec can't decode byte 0xe2 in position 2386: ordinal not in range(128)

If anyone could help me troubleshoot this, I would appreciate the help. I am new to MySQL, so please be as specific as possible in your instructions.

Thank you in advance.

mysqlmysql-workbench


Solution 1:[1]

For anyone else looking at this error in the future:

I had the same errors trying to run sql script.

I have downloaded the most recent MySQL Workbench 6 and am able to run script without issue. Props to user cucu8 who mentions this above.

https://downloads.mysql.com/archives/workbench/

Props to user cucu8 who mentions this above.

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 ffffff

Related Questions