MySQL Bugs: #17938: accented characters not restored properly

Bug #17938	accented characters not restored properly
Submitted:	5 Mar 2006 14:17	Modified:	11 Mar 2006 14:29
Reporter:	Brett Foster	Email Updates:
Status:	Not a Bug	Impact on me:	None
Category:	MySQL Administrator	Severity:	S1 (Critical)
Version:	1.1.9	OS:	Windows (Windows XP)
Assigned to:		CPU Architecture:	Any

Description:
I successfully backed up a MySQL database hosted on a remote Linux system (running MySQL 4.0.25) and verified that the accented characters are properly represented in the UTF-8 sql file.

However upon restoring this sql file in my local system (running MySQL 4.0.26) I find that accented characters are garbled. 

How to repeat:
Example source character data: papier-mâché

This is restored as: papier-mÃ¢chÃ©

Suggested fix:
I haven't found a workaround

Thank you for a problem report. Please, send both my.cnf file content (or SHOW VARIABLES results) from your Linux server, and my.ini (or SHOW VARIABLES results) from your local server.

show variables output files

Attachment: variables.zip (application/x-zip-compressed, text), 4.30 KiB.

Ok I just added the file "variables.zip" to the bug report. It contains the output of the show variables command from both systems as exported from MySQL Query Browser. 

backup.xml - output of Linux server where backup was run

restore.xml - output of Windows machine where restore was run

I just wanted to clarify, I think my last comment was a bit misleading. The backup was performed by running MySQL Administrator on Windows and connecting to a remote Linux server. Then the restore was performed by connecting to the Windows system (localhost).

my php fetch code turned out not to be portable. sorry for wasting cycles