Bug #114755 'charmap' codec can't encode character in position: character maps to <undefined
Submitted: 24 Apr 2024 7:08 Modified: 24 Apr 2024 13:06
Reporter: Karolina Piechowicz Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Workbench: SQL Editor Severity:S1 (Critical)
Version:8.3 OS:Windows (10)
Assigned to: CPU Architecture:Any
Tags: encoding

[24 Apr 2024 7:08] Karolina Piechowicz
Description:
Trying to export a database.

08:52:49 Dumping audioteka (lista_utworow)
Running: mysqldump.exe --defaults-file="C:\Users\K\AppData\Local\Temp\tmp39pfrrpa.cnf"  --host=localhost --port=3306 --default-character-set=utf8 --user=root --protocol=tcp --skip-triggers "audioteka" "lista_utworow"
Error executing task: 'charmap' codec can't encode character '\u0143' in position 8: character maps to <undefined>
Error executing task [WinError 32] The process cannot access the file because it is being used by another process: 'C:\\Users\\K\\AppData\\Local\\Temp\\tmp39pfrrpa.cnf'
08:52:50 Export of C:\Users\K\Documents\dumps\Dump20240423 (5) has finished

All I get is an empty file. I already figured the character is supposed to be Ń.
I checked the encoding with this:
SELECT CCSA.character_set_name FROM information_schema.`TABLES` T,information_schema.`COLLATION_CHARACTER_SET_APPLICABILITY` CCSA WHERE CCSA.collation_name = T.table_collation AND T.table_schema = "audioteka" AND T.table_name = "lista_utworow";
And got utf8mb4.

How to repeat:
I don't know how to repeat this bug.
[24 Apr 2024 13:06] MySQL Verification Team
Hello Karolina Piechowicz,

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

Regards,
Ashwini Patil