Thread: PostgreSQL encoding and PHP

PostgreSQL encoding and PHP

From
Alexandr Listopad
Date:
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

Re: PostgreSQL encoding and PHP

From
"Papp Gyozo"
Date:
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)