Обсуждение: Problem with pgAdmin and Server Status encode
<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>
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
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