X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 8B5918B9B33 for ; Tue, 22 Feb 2005 13:40:37 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 63775-09 for ; Tue, 22 Feb 2005 13:40:32 +0000 (GMT) Received: from mail.logi-track.com (burro.logi-track.com [213.239.193.212]) by svr1.postgresql.org (Postfix) with ESMTP id AE75F8B9E7A for ; Tue, 22 Feb 2005 13:40:34 +0000 (GMT) Received: from kingfisher.intern.logi-track.com (J1520.j.pppool.de [85.74.21.32]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) by mail.logi-track.com (Postfix) with ESMTP id D61093046A; Tue, 22 Feb 2005 14:40:37 +0100 (CET) Received: from [127.0.0.1] (localhost [127.0.0.1]) by kingfisher.intern.logi-track.com (Postfix) with ESMTP id 1F340AB2B8; Tue, 22 Feb 2005 14:40:33 +0100 (CET) Message-ID: <421B3650.2020203@logi-track.com> Date: Tue, 22 Feb 2005 14:40:32 +0100 From: Markus Schaber User-Agent: Mozilla Thunderbird 1.0 (X11/20050116) X-Accept-Language: de-DE, de, en-us, en MIME-Version: 1.0 To: Garry Cc: pgsql-sql@postgresql.org Subject: Re: problem inserting local characters ... References: <421B2D3E.5040205@gmx.de> In-Reply-To: <421B2D3E.5040205@gmx.de> X-Enigmail-Version: 0.90.1.0 X-Enigmail-Supports: pgp-inline, pgp-mime Content-Type: multipart/signed; micalg=pgp-ripemd160; protocol="application/pgp-signature"; boundary="------------enig3B1E18442514C3534424CCEA" X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.053 tagged_above=0 required=5 tests=AWL, FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200502/240 X-Sequence-Number: 20351 This is an OpenPGP/MIME signed message (RFC 2440 and 3156) --------------enig3B1E18442514C3534424CCEA Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Hi, Garry, Garry schrieb: > Trying to do this insert, I get an error on both the values > "TelefonGesch=E4ft" and "Firmenstra=DFe": >=20 > FEHLER: ung=C3=BCltige Byte-Sequenz f=C3=BCr Kodierung =C2=BBUNICODE=C2= =AB: 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) >=20 > 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 --=20 markus schaber | dipl. informatiker logi-track ag | rennweg 14-16 | ch 8001 z=FCrich phone +41-43-888 62 52 | fax +41-43-888 62 53 mailto:schabios@logi-track.com | www.logi-track.com --------------enig3B1E18442514C3534424CCEA Content-Type: application/pgp-signature; name="signature.asc" Content-Description: OpenPGP digital signature Content-Disposition: attachment; filename="signature.asc" -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.5 (GNU/Linux) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iD8DBQFCGzZQOVWsnapT9i0RA7BGAKCrb5iVV/eXrS/HUCYl7U0fptdBrwCaA6VS yH+pzmqDonAT5QCtOyUwbQE= =MZoo -----END PGP SIGNATURE----- --------------enig3B1E18442514C3534424CCEA--