MySQL Forums
Forum List  »  Character Sets, Collation, Unicode

Advanced Search
New Topic

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

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
MySQLAdministrator / MySQLDump generates ANSI instead of UTF8 - why ?
6144
Abraham Guyt
September 24, 2009 07:52PM
Re: MySQLAdministrator / MySQLDump generates ANSI instead of UTF8 - why ?
4424
Abraham Guyt
September 24, 2009 09:31PM
Re: MySQLAdministrator / MySQLDump generates ANSI instead of UTF8 - why ?
3576
Rick James
September 27, 2009 12:51PM


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.