From: Markus Schaber <schabios@logi-track.com>
To: Garry <gkg@gmx.de>
Cc: pgsql-sql@postgresql.org
Subject: Re: problem inserting local characters ...
Date: Tue, 22 Feb 2005 14:40:32 +0100
Message-ID: <421B3650.2020203@logi-track.com> (raw)
In-Reply-To: <421B2D3E.5040205@gmx.de>
References: <421B2D3E.5040205@gmx.de>
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@logi-track.com | www.logi-track.com
Attachments:
signature.asc (application/pgp-signature, 255B) download
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: schabios@logi-track.com, gkg@gmx.de
Subject: Re: problem inserting local characters ...
In-Reply-To: <421B3650.2020203@logi-track.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox