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 8C4595E48C9 for ; Tue, 7 Sep 2004 13:10:09 +0100 (BST) 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 67884-09 for ; Tue, 7 Sep 2004 12:10:06 +0000 (GMT) Received: from ns1.officenet.no (cD90888A8.sdsl.catch.no [217.8.136.168]) by svr1.postgresql.org (Postfix) with ESMTP id F090E5E4864 for ; Tue, 7 Sep 2004 13:10:00 +0100 (BST) Received: from [127.0.0.1] (helo=localhost) by ns1.officenet.no with esmtp (Exim 4.33) id 1C4ekD-0002Dc-25 for pgsql-sql@postgresql.org; Tue, 07 Sep 2004 14:06:41 +0200 From: Andreas Joseph Krogh Organization: OfficeNet AS To: pgsql-sql@postgresql.org Subject: Problem with LATIN1 characters from Perl-DBI Date: Tue, 7 Sep 2004 14:06:31 +0200 User-Agent: KMail/1.7 MIME-Version: 1.0 Content-Type: multipart/signed; boundary="nextPart45608388.JjGcsCxpjn"; protocol="application/pgp-signature"; micalg=pgp-sha1 Content-Transfer-Encoding: 7bit Message-Id: <200409071406.40262.andreak@officenet.no> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200409/42 X-Sequence-Number: 18888 --nextPart45608388.JjGcsCxpjn Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Hi. I have a database created with -E LATIN1. Inserting norwegian characters li= k=20 '=F8' works perfectly from JDBC, but from Perl, it stores the word 's=F8ker= ' as=20 's=C3=B8ker'(UNICODE). perl --version: This is perl, v5.8.3 built for i386-linux-thread-multi A Mandrake-10 Linux system. I first had the problem printing out LATIN1 chars to stdout too, but solved= =20 that by using the pragma use encoding 'ISO-8859-1'; I've tried: $dbh->do("set CLIENT_ENCODING TO 'ISO-8859-1'")=20 or die("Couldn't set encoding to ISO-8859-1"); but that didn't work. Any hints anyone? --=20 Andreas Joseph Krogh Senior Software Developer / Manager gpg public_key: http://dev.officenet.no/~andreak/public_key.asc ------------------------+---------------------------------------------+ OfficeNet AS | Two tomatoes in a fridge. One tomato says | Hoffsveien 17 | to the other, "It's cold in here, isn't it?"| PO. Box 425 Sk=F8yen | The other tomato says, "F**king hell, | 0213 Oslo | a talking tomato!" | NORWAY | | Phone : +47 22 13 01 00 | | Direct: +47 22 13 10 03 | | Mobile: +47 909 56 963 | | ------------------------+---------------------------------------------+ --nextPart45608388.JjGcsCxpjn Content-Type: application/pgp-signature -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.4 (GNU/Linux) iD8DBQBBPaRQUopImDh2gfQRAgy3AJ9xcpNUEA3v1wotOGpWkV/UbuwD5wCfc1YV 0lg7iYcN4gy3F+MPtiQFI/Y= =D21M -----END PGP SIGNATURE----- --nextPart45608388.JjGcsCxpjn--