| 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 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Giancarlo Boaron | 2010-05-20 14:05:13 | Some undefined function errors |
| Previous Message | Joshua Tolley | 2010-05-20 03:06:10 | Re: Bulk load straight into partitioned table? |