Bug #105140 importing csv file utf8 unicoded to mysqlworkbench dont working
Submitted: 5 Oct 2021 15:57 Modified: 6 Oct 2021 12:59
Reporter: mohamed atef Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Workbench: SQL Editor Severity:S1 (Critical)
Version:8.0.26 OS:Windows (64)
Assigned to: CPU Architecture:Any

[5 Oct 2021 15:57] mohamed atef 
Description:
when importing utf8 unicoded csv file return error 
charmap codec can`t decode byte 0x81 in position 84
character maps to <undefined>

How to repeat:
use mysqlworkbench version 8.0.26 in windows 10 64x

try to create excel file contain the following columns
id  CatEnName  CatArName
1   Cat1       مجموعة 1

then save this file and open it by apache openoffice Calc
then save the file as csv file and choose utf8 unicoding
then try to import the csv file to mysqlworkbench
select create new table and you will repeat the error

but when you use mysqlworkbench version 8.0.22 it will work

Suggested fix:
Fix Utf8 Decoding
[6 Oct 2021 12:59] MySQL Verification Team 
Hello mohamed atef,

Thank you for the bug report.
Imho this is duplicate of Bug #95700, please see Bug #95700.

Regards,
Ashwini Patil