Skip site navigation (1) Skip section navigation (2)

character encoding problem

From: Felix Obermaier <obe(at)IVV-AACHEN(dot)DE>
To: "'pgsql-novice(at)postgresql(dot)org'" <pgsql-novice(at)postgresql(dot)org>
Subject: character encoding problem
Date: 2010-05-20 12:41:19
Message-ID: 941E09AD62CA6F41913924A35EA3985EBD1C3B55@ivv-mx.ivv-aachen.de (view raw or flat)
Thread:
Lists: 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(at)ivv-aachen(dot)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

Next:From: Giancarlo BoaronDate: 2010-05-20 14:05:13
Subject: Some undefined function errors
Previous:From: Joshua TolleyDate: 2010-05-20 03:06:10
Subject: Re: Bulk load straight into partitioned table?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group