character encoding problem - Mailing list pgsql-novice

From Felix Obermaier
Subject character encoding problem
Date
Msg-id 941E09AD62CA6F41913924A35EA3985EBD1C3B55@ivv-mx.ivv-aachen.de
Whole thread Raw
List pgsql-novice
Hello list,

I received a dataset which has a wrong character encoding. It claims to be WIN1252, but it is not, since the german
'umlaute'are not shown right, e.g. 'ü' is \203\201 if i transform it to a byte array. 

- the server has 8.4.4,
- the database has 'UTF8' encoding and the locales are set to 'German_Germany.1252'

What do I proceed to correct the german 'umlaute'?

Thanks in advance

Felix Obermaier

------------------------------------------
 Ingenieurgruppe IVV GmbH & Co. KG
 Dipl.-Ing. Felix Obermaier
 Oppenhoffallee 171
 52066 Aachen

 Telefon: +49 (241) 94691-39
 Telefax: +49 (241) 531622
 eMail: obe@ivv-aachen.de
 Internet: http://www.ivv-aachen.de

 Sitz der Gesellschaft: Aachen
 Amtsgericht Aachen HRA 6212
 GF: Bauassessor Dr.-Ing. Dieter Hölsken
 IVV-Management GmbH
 Amtsgericht Aachen HRB 12543


pgsql-novice by date:

Previous
From: "Machiel Richards"
Date:
Subject: Setting up postgresql-8.3 on Debian
Next
From: Jim Lucas
Date:
Subject: Re: [PHP] Some undefined function errors