Received: from hapcibeno.freestart.hu (hapcibeno.freestart.hu [213.197.64.8]) by postgresql.org (8.11.3/8.11.4) with ESMTP id f9QGDhP46047 for ; Fri, 26 Oct 2001 12:13:44 -0400 (EDT) (envelope-from pgerzson@freestart.hu) Received: from erinyes.freestart.hu ([213.197.64.251] helo=jaguar) by freestart.hu with smtp (Freestart relay 2 (FS-Lin)) id 15x9so-0006iP-00; Fri, 26 Oct 2001 18:30:58 +0200 Message-ID: <001901c15e39$630c93c0$01fdfea9@jaguar> From: "Papp Gyozo" To: "Alexandr Listopad" , References: <20011026173551.V81610@laa.zp.ua> Subject: Re: PostgreSQL encoding and PHP Date: Fri, 26 Oct 2001 18:15:09 +0200 X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 X-Scanner: exiscan by Freestart X-Archive-Number: 200110/92 X-Sequence-Number: 645 I don't know the exact asnwer (perhaps I've not clearly understood what you want), but: there is several PHP extensions to deal with converting files between various coded character sets and surface encodings : 1. iconv http://www.php.net/manual/en/ref.iconv.php 2. recode http://www.php.net/manual/en/ref.recode.php 3. multibyte http://www.php.net/manual/en/ref.mbstring.php you can also set your client encoding in PHP with pg_set_client_encoding() http://www.php.net/manual/en/function.pg-set-client-encoding.php and maybe you can pass some encoding information in the options argument during connection. I'm not sure about this one. hope this helps, Papp Gyozo - pgerzson@freestart.hu > Hi! > > I have the database with win1251 encoding. My web site use koi8 > encoding. I use PHP 4.0.8-dev + Apache 1.3.20. > > How can I change encoding in database replays from win to koi in > PHP best way? > > p.s. sorry for my bad english. > > -- > Laa > > ---------------------------(end of broadcast)--------------------------- > TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)