MySQL Bugs: #105656: Unhandled exception: 'ascii' codec can't decode byte 0xef in position 0: ordinal

Bug #105656	Unhandled exception: 'ascii' codec can't decode byte 0xef in position 0: ordinal
Submitted:	22 Nov 2021 9:32	Modified:	22 Dec 2021 12:22
Reporter:	Akhir Syabani	Email Updates:
Status:	No Feedback	Impact on me:	None
Category:	MySQL Workbench	Severity:	S1 (Critical)
Version:	8.0.27	OS:	MacOS (Big Sur 11.6)
Assigned to:	MySQL Verification Team	CPU Architecture:	Any

Description:
When trying to import a CSV file using the wizard i get the following error:
Unhandled exception: 'ascii' codec can't decode byte 0xef in position 0: ordinal not in range (128).

I cannot load any CSV files to my database at the moment.

My friend tried in Windows and it worked just fine.

I have tried to install older version of Workbench but the app couldn't even start in MacOS Big Sur (incompatible).

I have seen this problem posted online but so far no useful solution.

How to repeat:
I tried multiple different CSV files without success.
My friend tried in Windows and it worked just fine.
I have tried to install older version of Workbench but the app couldn't even start in MacOS Big Sur (incompatible).

Suggested fix:
Nothing so far.

Looks like duplicate of https://bugs.mysql.com/bug.php?id=87788.

No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".

I'm also seeing this bug.
I added a CSV file with nothing but text and continue to see it.
using Version 8.0.28

We see the same thing in version 8.0.28 running under MacOS 12.3

Same problem in Workbench version 8.0.29 running under MacOS 12.4
Impossible to import a CSV file using any of the possible encoding.
The file to import is using a UTF-8 encoding.