Package: phpbb2
Version: 2.0.12-1
Severity: normal
Hi,
our postgres uses UTF8, the apache server on default iso-8859-1 and the
templates provided from the package are also using this charset.
first, in 2005 it should be standard to use iso-8859-15 so the "Euro"
Curreny Symbol is shown correctly.
for the apache config a
php_value default_charset "iso-8859-15"
would do the correct thing, so adding this to the config example would
be nice.
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;
}
-- System Information:
Debian Release: 3.1
APT prefers testing
APT policy: (500, 'testing'), (1, 'experimental')
Architecture: i386 (i686)
Kernel: Linux 2.4.28
Locale: LANG=C, [EMAIL PROTECTED] (charmap=ISO-8859-15)
Versions of packages phpbb2 depends on:
ii apache [httpd] 1.3.33-3 versatile, high-performance HTTP s
ii apache2-mpm-prefork [httpd] 2.0.52-3 Traditional model for Apache2
ii debconf 1.4.30.11 Debian configuration management sy
ii libapache2-mod-php4 4:4.3.10-2 server-side, HTML-embedded scripti
ii php4 4:4.3.10-2 server-side, HTML-embedded scripti
ii php4-cgi 4:4.3.10-2 server-side, HTML-embedded scripti
ii php4-pgsql 3:4.3.9-1 PostgreSQL module for php4
-- debconf information:
* phpbb2/httpd: apache2
--
To UNSUBSCRIBE, email to [EMAIL PROTECTED]
with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
