Re: MySQLAdministrator / MySQLDump generates ANSI instead of UTF8 - why ?
Posted by: Abraham Guyt
Date: September 24, 2009 09:31PM

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).

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: MySQLAdministrator / MySQLDump generates ANSI instead of UTF8 - why ?
4240
September 24, 2009 09:31PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.