Re: MySQLAdministrator / MySQLDump generates ANSI instead of UTF8 - why ?

[Abraham Guyt]

Strange ....

After some more testing it seems that all dumps with just table creation code and some very small tables with only ASCII are always in ANSI instead of UTF8, this seems to be automatic behaviour of mysqldump + MySQL Administrator.

A bit confusing ...

Another useful tip when using mysqldump + redirection under PowerShell, the default output is a Unicode (instead of UTF8) file. To make sure you get a UTF8 output file you have to use:

mysqldump -u <user> <db> | Out-File <file> -encoding UTF8

At the moment there's no automatic setting for that ($OutputEncoding doesn't work).