X-Original-To: pgsql-php-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id DA14655DD6 for ; Sat, 5 Mar 2005 08:59:20 +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 83064-05 for ; Sat, 5 Mar 2005 08:59:17 +0000 (GMT) Received: from sranda.klamovka.kosire.czf (unknown [82.113.63.66]) by svr1.postgresql.org (Postfix) with ESMTP id ABC3E55CF0 for ; Sat, 5 Mar 2005 08:59:15 +0000 (GMT) Received: (qmail 25350 invoked from network); 5 Mar 2005 09:59:17 +0100 Received: from fordfrog.klamovka.kosire.czf (HELO ?192.168.11.101?) (10.15.70.18) by smtp.klamovka.kosire.czf with AES256-SHA encrypted SMTP; 5 Mar 2005 09:59:17 +0100 Message-ID: <422974E9.9010501@startnet.cz> Date: Sat, 05 Mar 2005 09:59:21 +0100 From: =?UTF-8?B?TWlyb3NsYXYgxaB1bGM=?= Organization: StartNet s.r.o. User-Agent: Mozilla Thunderbird 1.0 (X11/20041208) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Markus Bertheau Cc: Zouari Fourat , Christopher Kings-Lynne , pgsql-php@postgresql.org Subject: Re: unicode and frensh accents References: <621eda8a0503030622837a19e@mail.gmail.com> <42271EF4.8090109@familyhealth.com.au> <621eda8a0503030714e43bc79@mail.gmail.com> <42272C2B.7030903@familyhealth.com.au> <621eda8a050303075141e910a4@mail.gmail.com> <1109982973.4308.6.camel@umnik> In-Reply-To: <1109982973.4308.6.camel@umnik> X-Enigmail-Version: 0.89.5.0 X-Enigmail-Supports: pgp-inline, pgp-mime Content-Type: multipart/mixed; boundary="------------080405050805080703040906" X-Virus-Scanned: by amavisd-new at hub.org X-Archive-Number: 200503/23 X-Sequence-Number: 3038 This is a multi-part message in MIME format. --------------080405050805080703040906 Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit Maybe you could send us the code that retrieves the data from PostgreSQL. I personally use 'pg_set_client_encoding($link, 'UNICODE');' before I get data from server to be sure I get it in utf-8 encoding. Other thing that might be a problem is that default Apache configuration file contains 'AddDefaultCharset ISO-8859-1' instruction which sets default charset in case the Apache cannot find one in the page. Disabling this makes characters unmangled (it may and probably should by solved other way but I didn't spend my time on figuring how). Miroslav Šulc Markus Bertheau wrote: >У Чтв, 2005-03-03 у 16:51 +0100, Zouari Fourat пише: > > >>ok i admit... >>that last one is wrong, the page when saved displays well formed data... >> >>but what about header('... charset=UTF-8 statement ? it doesnt occur >>in phppgadmin files ... >> >> > >Right, we don't set it. Usually Apache does if not told otherwise. > >What do you get from your own script? Best make a screenshot. > >Markus > > > --------------080405050805080703040906 Content-Type: text/x-vcard; charset=utf-8; name="miroslav.sulc.vcf" Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename="miroslav.sulc.vcf" YmVnaW46dmNhcmQNCmZuO3F1b3RlZC1wcmludGFibGU6TWlyb3NsYXYgPUM1PUEwdWxjDQpu O3F1b3RlZC1wcmludGFibGU6PUM1PUEwdWxjO01pcm9zbGF2DQpvcmc6U3RhcnROZXQgcy5y Lm8uDQphZHI7cXVvdGVkLXByaW50YWJsZTtxdW90ZWQtcHJpbnRhYmxlOjs7VnJjaGxpY2s9 QzM9QTlobyAxNjEvNTtQcmFoYSA1OzsxNTAgMDA7PUM0PThDZXNrPUMzPUExIHJlcHVibGlr YQ0KZW1haWw7aW50ZXJuZXQ6bWlyb3NsYXYuc3VsY0BzdGFydG5ldC5jeg0KdGl0bGU6Q0VP DQp0ZWw7d29yazorNDIwIDI1NyAyMjUgNjAyDQp0ZWw7Y2VsbDorNDIwIDYwMyA3MTEgNDEz DQp4LW1vemlsbGEtaHRtbDpUUlVFDQp1cmw6aHR0cDovL3d3dy5zdGFydG5ldC5jeg0KdmVy c2lvbjoyLjENCmVuZDp2Y2FyZA0KDQo= --------------080405050805080703040906--