Re: German umlauts in pgadmin III

From: Andreas Pflug <pgadmin(at)pse-consulting(dot)de>
To: Albin Blaschka <Albin(dot)Blaschka(at)bal(dot)bmlfuw(dot)gv(dot)at>
Cc: "'pgadmin-support(at)postgresql(dot)org'" <pgadmin-support(at)postgresql(dot)org>, Dave Page <dpage(at)vale-housing(dot)co(dot)uk>
Subject: Re: German umlauts in pgadmin III
Date: 2003-10-23 11:02:55
Message-ID: 3F97B55F.7070103@pse-consulting.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

Albin Blaschka wrote:

>>Hello,
>>
>>Thanks for all the answers, I solved the problem with "converting" my
>>databases to Latin1...
>>(dumping the data, dropping the DB, recreate it with Latin1, reloading
>>data)
>>
>>Was quite an effort, but did it and without problems...
>>
>>BTW: PGAdmin III, V1.01 did *not* work in that case (displaying german
>>umlaute properly...)
>>
>>Thanks,
>>Albin
>>
>>--
>>************************************************************************
>>** Albin Blaschka, Mag. rer. nat.
>>** BAL Gumpenstein
>>** Projekt: Landschaft und Landwirtschaft im Wandel
>>** Tel.: 03682 / 22451 - 244
>>** No trees were killed in the creation of this message.
>>** However, many electrons were terrible inconvenienced.
>>************************************************************************
>>
>>
>>
>>
>>
>>----------
>>Von: Dave Page[SMTP:dpage(at)vale-housing(dot)co(dot)uk]
>>Gesendet: Mittwoch, 22. Oktober 2003 13:28
>>An: Andreas Pflug; Albin Blaschka
>>Cc: pgadmin-support(at)postgresql(dot)org; Reinhard Resch; Wilhelm Graiss
>>Betreff: RE: [pgadmin-support] German umlauts in pgadmin III
>>
>>
>>
>>
>>
>>>-----Original Message-----
>>>From: Andreas Pflug [mailto:pgadmin(at)pse-consulting(dot)de]
>>>Sent: 20 October 2003 10:07
>>>To: Albin Blaschka
>>>Cc: 'pgadmin-support(at)postgresql(dot)org'; Reinhard Resch; Wilhelm Graiss
>>>Subject: Re: [pgadmin-support] German umlauts in pgadmin III
>>>
>>>Umlaute are no ascii chars, so they can't converted to unicode.
>>>V1.0.1 which was released some days ago has a workaround for
>>>miscoded databases, leaving encoding conversions to the
>>>client if the db is created SQL_ASCII.
>>>
>>>
>>I just ran into this on my system with the £ symbol (UK Pound symbol, not
>>#), however the fix doesn't seem to work in CVS tip - Any column that
>>contains a £ value anywhere in it shows up as having a null value. At very
>>least I would expect to see an 'unknown char' symbol in place of the pound
>>sign, and the rest of the string intact.
>>
>>Regards, Dave.
>>
>>
>>
>>

While the conversion *is* correctly determined for each connection, it
wasn't applied in pgSet...
Done now (head and trunk).

Regards,
Andreas

In response to

Browse pgadmin-support by date

  From Date Subject
Next Message Andreas Pflug 2003-10-23 11:08:39 Re: [pgadmin-support] EXPORT from Query Tool
Previous Message Andreas Pflug 2003-10-23 10:51:04 Re: Very slow viewing of large table.