Re: BUG #6742: pg_dump doesn't convert encoding of DB object names to OS encoding - Mailing list pgsql-bugs

exclusion@gmail.com, 18.07.2012 09:17:
> The following bug has been logged on the website:
>
> Bug reference:      6742
> Logged by:          Alexander LAW
> Email address:      exclusion@gmail.com
> PostgreSQL version: 9.1.4
> Operating system:   Windows
> Description:
>
> When I try to dump database with UTF-8 encoding in Windows, I get unreadable
> object names.
> Please look at the screenshot (http://oi50.tinypic.com/2lw6ipf.jpg). On the
> left window all the pg_dump messages displayed correctly (except for the
> prompt password (bug #6510)), but the non-ASCII object name is gibberish. On
> the right window (where dump is done with the Windows 1251 encoding (OS
> Encoding for Russian locale)) everything is right.
>
Did you check the dump file using an editor that can handle UTF-8?
The Windows console is not known for properly handling that encoding.

Thomas