Postgres Pro
Downloads
Home   >   mailing lists

Thread: Problem with pgAdmin and Server Status encode

Problem with pgAdmin and Server Status encode

From
"Manuel Fdez \(JVR\)"
Date:
<div class="WordSection1"><p class="MsoNormal"><span lang="EN-US">Version pgAdminIII: 1.16.1</span><p
class="MsoNormal"><spanlang="EN-US"> </span><p class="MsoNormal"><span lang="EN-US">Server PostgreSQL: 9.1</span><p
class="MsoNormal"><spanlang="EN-US"> </span><p class="MsoNormal"><span lang="EN-US">OS: Windows 7 Professional
SP1</span><pclass="MsoNormal"><span lang="EN-US"> </span><p class="MsoNormal"><span lang="EN-US">When I try to open
ServerStatus I receive this message continuously:</span><p class="MsoNormal"><span lang="EN-US"> </span><p
class="MsoNormal"><imgalt="cid:image001.png@01CE1069.DB3DBD30" height="199" id="Imagen_x0020_1"
src="cid:image001.png@01CE1076.CA9634F0"width="455" /><span lang="EN-US"></span><p class="MsoNormal"><span
lang="EN-US"> </span><pclass="MsoNormal"><span lang="EN-US">My Database encode: UTF8 and Collation and Charset Spanish,
Spain.</span><pclass="MsoNormal"><span lang="EN-US"> </span><p class="MsoNormal">Thanks.<p class="MsoNormal"> <p
class="MsoNormal"> <pclass="MsoNormal"> <p
class="MsoNormal">_______________________________________________________________________________________________________________________________________________<p
class="MsoNormal">ManuelFco. Fernánde Ponce<p class="MsoNormal">manuel.fernandez@joyeriavirgendelrocio.com<p
class="MsoNormal">Responsablede Informática de Joyería Virgen del Rocío, SCA<p class="MsoNormal">Teléfono: 617 316
354<pclass="MsoNormal"> </div>

Re: Problem with pgAdmin and Server Status encode

From
Guillaume Lelarge
Date:
On Thu, 2013-02-21 at 21:02 +0100, Manuel Fdez (JVR) wrote:
> Version pgAdminIII: 1.16.1
> 
>  
> 
> Server PostgreSQL: 9.1
> 
>  
> 
> OS: Windows 7 Professional SP1
> 
>  
> 
> When I try to open Server Status I receive this message continuously:
> 
>  
> 
> cid:image001.png@01CE1069.DB3DBD30
> 
>  
> 
> My Database encode: UTF8 and Collation and Charset Spanish, Spain.
> 

Well, I don't know spanish but I can guess what this message says. You
have multiple encodings on your logs, and pgadmin doesn't like that at
all. Unfortunately, there's not much you can do. PostgreSQL only puts
UTF8 strings in it, but if it has to output SQL queries (because you
asked it to do so or because there are errors on these queries), they
may contain non-UTF8 characters.


-- 
Guillaume
http://blog.guillaume.lelarge.info
http://www.dalibo.com

Re: Problem with pgAdmin and Server Status encode

From
"Jan-Peter Seifert"
Date:
Hello,

-------- Original-Nachricht --------
> Datum: Sat, 23 Feb 2013 15:56:50 +0100
> Von: Guillaume Lelarge <guillaume@lelarge.info>
> An: "Manuel Fdez (JVR)" <manuel.fernandez@joyeriavirgendelrocio.com>
> CC: pgadmin-support@postgresql.org
> Betreff: Re: [pgadmin-support] Problem with pgAdmin and Server Status encode

> Well, I don't know spanish but I can guess what this message says. You
> have multiple encodings on your logs, and pgadmin doesn't like that at
> all. Unfortunately, there's not much you can do. PostgreSQL only puts
> UTF8 strings in it, but if it has to output SQL queries (because you
> asked it to do so or because there are errors on these queries), they
> may contain non-UTF8 characters.

I suspect that the problem is on the server's side.
On Windows ( Windows 7 Enterprise 64-Bit ) the default German 'locale' for UTF8 set by the 'One click installer' is
"German_Germany.1252".

So instead of 'autovacuum launcher shutting down' 'Autovacuum-Launcher fährt herunter' is being logged. The problem is
thatthe ä (ae) is not encoded in UTF8 ( just one byte ). Maybe the reason is that the encoding of code page 1252 is in
factjust a one byte encoding and no conversion is being done?
 

I checked this on Ubuntu and although the locale is "de_DE.utf8" everywhere, the messages in the logs were all in
English...
 
So I use "lc_messages = 'C'" as recommended elsewhere on the list.

With best regards,

Peter