Bug #9977 Error with backup in portuguese(pt-BR) languague
Submitted: 18 Apr 2005 16:01 Modified: 26 Apr 2005 19:18
Reporter: Rony Reinehr Brand Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Administrator Severity:S2 (Serious)
Version: OS:Linux (Linux Mandrake 10.0)
Assigned to: CPU Architecture:Any

[18 Apr 2005 16:01] Rony Reinehr Brand
Description:
I had a problem when i backup database with data in portuguese(pt-BR) languague like 'ç', 'ã', 'é'... 
The SQL File show caracter like 'ç', 'ã' 'é,'... and then i can't restore the database because many words are unreadble.
When I export with SQLyog this problem don't occur.

Thanks 

How to repeat:
Export a database with data in portuguese(pt-BR) languague like 'ç', 'ã', 'é'... 
The SQL File show caracter like 'ç', 'ã' 'é,'... and then i can't restore the database because many words are unreadble.

Suggested fix:
Maybe contact with SQLyog developers, to know how they have solve this problem.
[20 Apr 2005 14:36] Jorge del Conde
Was able to reproduce with spanish characters (á,é,ñ)
[26 Apr 2005 19:18] Michael G. Zinner
The backup is in UTF8. Open it as UTF8 file in wordpad / notepad and it will look fine.