MySQL Bugs: #3999: BACKUP and Latin characters

Bug #3999	BACKUP and Latin characters
Submitted:	4 Jun 2004 11:42	Modified:	4 Jun 2004 11:52
Reporter:	Tiago Janz	Email Updates:
Status:	Not a Bug	Impact on me:	None
Category:	MySQL Administrator	Severity:	S2 (Serious)
Version:	1.0.4 BETA	OS:	Windows (WIN XP pro)
Assigned to:	Ulrich Bayer	CPU Architecture:	Any

Description:
When doing a backup of MyIsam tables with Portuguese characters those same characters got unreadable in the mysql file

Backup 
classificar fotos\r\n\r\npara cada original \r\n  dar um nome\r\n  encontrar o equivalente mÃ©dio e pequeno e mudar o nome\r\n  colocar as trÃªs na pasta certa\r\n\r\ntipo:\r\n

Should read
classificar fotos\r\n\r\npara cada original \r\n  dar um nome\r\n  encontrar o equivalente médio e pequeno e mudar o nome\r\n  colocar as três na pasta certa\r\n\r\ntipo:\r\n

How to repeat:
Just make a backup of a table containing special charaters

Suggested fix:
The file must be saved as unicode

Hi,

The file is actually saved as UTF-8. So they are unreadable in a normal text-editor. You should however have no problems to restore them with the Mysql Administrator or a mysql 4.1 client. (The mysql 4.0 - cmdlineclient does not understand UTF-8)