On Tue, 08 Mar 2005, Florian Reitmeir wrote:

> Then the connection php <-> database is broken, because like we
> mentioned we use UTF8 (i don't no, if mysql has proper charset
> handling).
> 
> We fixed the database layer, always to do the correct thing:
> 
> --- postgres7.php.orig        2005-03-08 17:07:07.000000000 +0100
> +++ postgres7.php     2005-03-08 17:10:35.000000000 +0100
> @@ -86,6 +86,12 @@
>  
>               $this->db_connect_id = ( $this->persistency ) ? 
> pg_pconnect($this->connect_string) : pg_connect($this->connect_string);
>  
> +             # Use the same encoding for our connection to the DB as we do 
> for talking with
> +             # clients.  That allows us to pass in user input containing 
> non-ascii chars into
> +             # the database properly.
> +             $encoding = ini_get ( 'default_charset' );
> +             pg_set_client_encoding ( $this->db_connect_id, $encoding );
> +
>               return ( $this->db_connect_id ) ? $this->db_connect_id : false;
>       }

Any chance you could apply this patch any time soon?


-- 
 PGP signed and encrypted  |  .''`.  ** Debian GNU/Linux **
    messages preferred.    | : :' :      The  universal
                           | `. `'      Operating System
 http://www.palfrader.org/ |   `-    http://www.debian.org/


-- 
To UNSUBSCRIBE, email to [EMAIL PROTECTED]
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]

Reply via email to