Skip site navigation (1) Skip section navigation (2)

Re: Backup messages displayed with wrong encoding

From: Guillaume Lelarge <guillaume(at)lelarge(dot)info>
To: Alexander LAW <exclusion(at)gmail(dot)com>
Cc: pgadmin-support(at)postgresql(dot)org
Subject: Re: Backup messages displayed with wrong encoding
Date: 2011-12-13 20:20:31
Message-ID: 1323807631.4359.78.camel@localhost.localdomain (view raw, whole thread or download thread mbox)
Lists: pgadmin-support
On Tue, 2011-12-13 at 08:15 +0400, Alexander LAW wrote:
> Hi,
> To make it clear I am posting two screenshots.
> ss_backup_win1251 shows valid table name (which is "Test" in Russian), 
> but in ss_backup_utf8 you can see the name with wrong encoding.
> When I said "pgAdmin assumes", I meant that it converts pg_admin output 
> stream to string as ANSI-encoded, but it's not always the case.
> In fact, the opposite is common on Windows with Russian locale (and 
> non-ASCII object names), cause UTF-8 is a default encoding for a 
> database, but locale encoding (SBCS) is Win1251, and when you do backup 
> with a default encoding, you get an unreadable log.

pgAdmin simply displays what pg_dump gives him. If it's in the right
encoding, you'll see your tables' name correct. I'm not sure it would be
a good idea to grab every line and to convert them in whatever encoding
pgAdmin would like. If it's possible at all.


In response to


pgadmin-support by date

Next:From: Guillaume LelargeDate: 2011-12-13 20:22:45
Subject: Re: SQL not showing in generated report
Previous:From: Rick DicaireDate: 2011-12-13 15:31:21
Subject: Re: SQL not showing in generated report

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group