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
• Status: Duplicate
• Category: MySQL Workbench: SQL Editor
• Severity: S1 (Critical)
• Version: 8.3
• OS: Windows (10)
• 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