Bug #110023 "error during data import: UnicodeDecodeError" when importing csv

• Submitted: 10 Feb 2023 9:32
• Modified: 10 Feb 2023 12:54
• Reporter: winalo winalo
• Status: Duplicate
• Category: MySQL Workbench: Modeling
• Severity: S3 (Non-critical)
• Version: 8.0.32
• OS: Windows (10)
• CPU Architecture: x86

[10 Feb 2023 9:32] winalo winalo

Description:

error during data import: UnicodeDecodeError(" 'charmap' codec can't be decoded byte 0x8d in position 7: character maps to <undifined>")

How to repeat:
create a model

create a table with 2 columns id and name (int and tinytext)

go to "inserts" tab

insert this a row  : id = 5020 name ="Ísöld ehf"

apply change

export recordset to an external file

save as "data.csv"

now delete row

import records from an external file

select "data.csv"

boom error

error during data import: UnicodeDecodeError(" 'charmap' codec can't be decoded byte 0x8d in position 7: character maps to <undifined>")

problem seem to be about Í in Ísöld ehf

note that if i want Database->Forward Engineering and select "Generate INSERT statements for tables" there is no mysql bug, data are visible and everything is ok

so problem come from import csv tool
that cant read what it export

Suggested fix:
problem with utf-8 encoding for reading but not for writing ?

[10 Feb 2023 12:54] MySQL Verification Team

Hello,

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

Regards,
Ashwini Patil