FAQ
Hi,

I've got a remote db host that runs PG 8.4.x DBs in UNICODE german.
I connect with pgAdmin from Win-XP and everything is nice as long as I
look into tables or the nontranslated DDL stuff that pgAdmin creates.

The translated error messages e.g. in the logfile show weired
characters, though.
Obviously the PG server sends UTF-8 and the client doesn't understand.

The DBs are UNICODE so the client-encoding defaults to UNICODE, too.
pgAdmin uses Tahoma with Widows-1252 encoding but I can't find a switch
to set it to Unicode.


What to do ?

Search Discussions

  • Mladen Gogala at May 14, 2010 at 7:32 pm

    Andreas wrote:
    Hi,

    I've got a remote db host that runs PG 8.4.x DBs in UNICODE german.
    I connect with pgAdmin from Win-XP and everything is nice as long as I
    look into tables or the nontranslated DDL stuff that pgAdmin creates.

    The translated error messages e.g. in the logfile show weired
    characters, though.
    Obviously the PG server sends UTF-8 and the client doesn't understand.

    The DBs are UNICODE so the client-encoding defaults to UNICODE, too.
    pgAdmin uses Tahoma with Widows-1252 encoding but I can't find a switch
    to set it to Unicode.


    What to do ?

    Andreas, what you are looking at is not an encoding, it's a font option.
    Use some German font in there, the characters should be fine. The
    PgAdminIII on MS-Windows is using the system encoding. Viel Gluck.

    --

    Mladen Gogala
    Sr. Oracle DBA
    1500 Broadway
    New York, NY 10036
    (212) 329-5251
    http://www.vmsinfo.com
    The Leader in Integrated Media Intelligence Solutions

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouppgsql-novice @
categoriespostgresql
postedMay 14, '10 at 1:30p
activeMay 14, '10 at 7:32p
posts2
users2
websitepostgresql.org
irc#postgresql

2 users in discussion

Andreas: 1 post Mladen Gogala: 1 post

People

Translate

site design / logo © 2022 Grokbase