MySQLWorkbench - error message - Unhandled exception: 'ascii' codec can't decode byte Oxe4 in position 9: ordinal not in range (128)
2
votes
3
answers
3901
views
I was trying to use table data import wizard to import a csv file that uses utf-8 character set, and then the following error message shows up.
>MySQLWorkbench - error message - Unhandled exception: 'ascii' codec can't decode byte Oxe4 in position 9: ordinal not in range (128)
I have tried to set the schema's character set to utf-8/utfmb4, but it didn't work. The csv file is converted from Excel, and all its cells have been set to text form. I have to use utf-8 for the needed table for future use. How can I import this csv file? Do I need to change the server and the database's encoding language? If so, how can I do this on Mac?

Asked by L_flo
(21 rep)
Apr 26, 2023, 02:21 AM
Last activity: Jun 28, 2025, 03:09 PM
Last activity: Jun 28, 2025, 03:09 PM