X-Original-To: pgsql-php@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id A0A30475458 for ; Wed, 30 Apr 2003 03:51:35 -0400 (EDT) Received: from saphir (dsl-213-023-155-049.arcor-ip.net [213.23.155.49]) by postgresql.org (Postfix) with ESMTP id BA771474E42 for ; Wed, 30 Apr 2003 03:51:32 -0400 (EDT) Received: by saphir (Postfix, from userid 1000) id 2F988131013; Wed, 30 Apr 2003 09:51:30 +0200 (CEST) Subject: Re: Encoding issues From: Markus Bertheau To: Dani Oderbolz Cc: pgsql-php@postgresql.org In-Reply-To: <3EAD0D1D.7010403@ecologic.de> References: <3EAD0D1D.7010403@ecologic.de> Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Organization: Message-Id: <1051689089.2476.1.camel@saphir> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.3.2.99 (Preview Release) Date: 30 Apr 2003 09:51:30 +0200 X-Spam-Status: No, hits=-29.4 required=5.0 tests=BAYES_20,IN_REP_TO,QUOTED_EMAIL_TEXT,QUOTE_TWICE_1, REFERENCES,REPLY_WITH_QUOTES,USER_AGENT_XIMIAN 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/34 X-Sequence-Number: 2004 =D0=92 =D0=9F=D0=BD=D0=B4, 28.04.2003, =D0=B2 13:14, Dani Oderbolz =D0=BF= =D0=B8=D1=88=D0=B5=D1=82: > Hi all, >=20 > I have got a problem with the encoding of special caracters. > My DB uses the Encoding 'LATIN1'. > I modify data like this in psql: >=20 > SET CLIENT_ENCODING =3D 'LATIN1'; > update auftraggeber set name_de=3D'Europ=C3=A4ische Union'; Where specificially does the string "Europ=C3=A4ische Union" come from? Is = it input in a web form? >=20 > When I access this in PHP (using this Query: > SET CLIENT_ENCODING =3D 'LATIN1'; > select name_de from projekte.sel_auftraggeber; >=20 > I get this: >=20 > Europ=C3=83=C2=A4ische Union This looks like UTF-8. --=20 Markus Bertheau. Berlin, Berlin. Germany.