Re: problem inserting local characters ...

From: Markus Schaber <schabios(at)logi-track(dot)com>
To: Garry <gkg(at)gmx(dot)de>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: problem inserting local characters ...
Date: 2005-02-22 13:40:32
Message-ID: 421B3650.2020203@logi-track.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi, Garry,

Garry schrieb:

> Trying to do this insert, I get an error on both the values
> "TelefonGeschäft" and "Firmenstraße":
>
> FEHLER: ungültige Byte-Sequenz für Kodierung »UNICODE«: 0xe165

This sounds as your database was created in unicode (utf-8).

> (the 0xe165 differs between the two; the fields in question are regular
> type "text" fields)
>
> Looks like I'm having some trouble with unicode encoding ... The
> characters I have are regular 8bit ASCII chars ... How can I fix this?

No, 8bit ASCII does not exist. ASCII always is 7 bit. As your error
message is in German, I suspect your data is encoded in LATIN1 or LATIN9
(their only difference is the EUR symbol in the latter one).

Can you try to add the following command before your insert statements:

set client_encoding to latin1;

HTH,
Markus

--
markus schaber | dipl. informatiker
logi-track ag | rennweg 14-16 | ch 8001 zürich
phone +41-43-888 62 52 | fax +41-43-888 62 53
mailto:schabios(at)logi-track(dot)com | www.logi-track.com

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message George Weaver 2005-02-22 13:45:46 Re: Working with XML.
Previous Message Markus Schaber 2005-02-22 13:36:16 Re: pg primary key bug?