X-Original-To: pgsql-php@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 1C97A4758C9 for ; Mon, 28 Apr 2003 07:15:19 -0400 (EDT) Received: from moutng.kundenserver.de (moutng.kundenserver.de [212.227.126.184]) by postgresql.org (Postfix) with ESMTP id 6FEE3474E42 for ; Mon, 28 Apr 2003 07:15:18 -0400 (EDT) Received: from [212.227.126.205] (helo=mrelayng.kundenserver.de) by moutng.kundenserver.de with esmtp (Exim 3.35 #1) id 19A6bR-0005D7-00 for pgsql-php@postgresql.org; Mon, 28 Apr 2003 13:15:21 +0200 Received: from [217.230.195.131] (helo=ecologic.de) by mrelayng.kundenserver.de with asmtp (Exim 3.35 #1) id 19A6bQ-0003F8-00 for pgsql-php@postgresql.org; Mon, 28 Apr 2003 13:15:20 +0200 Message-ID: <3EAD0D1D.7010403@ecologic.de> Date: Mon, 28 Apr 2003 13:14:37 +0200 From: Dani Oderbolz User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.3) Gecko/20030312 X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-php@postgresql.org Subject: Encoding issues Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: quoted-printable X-Spam-Status: No, hits=-11.2 required=5.0 tests=BAYES_01,RCVD_IN_NJABL,RCVD_IN_OSIRUSOFT_COM, USER_AGENT_MOZILLA_UA autolearn=ham version=2.50 X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp) X-Archive-Number: 200304/29 X-Sequence-Number: 1999 Hi all, I have got a problem with the encoding of special caracters. My DB uses the Encoding 'LATIN1'. I modify data like this in psql: SET CLIENT_ENCODING =3D 'LATIN1'; update auftraggeber set name_de=3D'Europ=E4ische Union'; When I access this in PHP (using this Query: SET CLIENT_ENCODING =3D 'LATIN1'; select name_de from projekte.sel_auftraggeber; I get this: Europ=C3=A4ische Union Hhhm. Is there something I miss here? Is there a way to specify a "standard" encoding in PHP, so that I don't have to set the encoding? Thanks for your help, cheers, Dani