Changeset 993

Timestamp:

02/07/08 10:05:37 (7 months ago)

Author:

joximu

Message:

Added: use utf8 with the database, including config var to switch off

Files:

• trunk/CHANGELOG (modified) (1 diff)
• trunk/configs/apache/httpd.conf (modified) (1 diff)
• trunk/configs/ispcp.conf (modified) (1 diff)
• trunk/gui/include/sql.php (modified) (1 diff)

trunk/CHANGELOG

@@ -1 +1 @@
-ispCP ω 1.0.0 Changelog
-~~~~~~~~~~~~~~~~~~~~~~~~~~~~
+
+2008-02-07 Christian Hernmarck
+        - GUI:
+                * Added: use utf8 with the database, including config var to switch off
-
-2008-02-05 Benedikt Heintel

trunk/configs/apache/httpd.conf

@@ -27 +27 @@
-
-#
+# let the customer decide what charset he likes to use
+#
+
+AddDefaultCharset Off
+
+#
-# Header End
-#

trunk/configs/ispcp.conf

@@ -108 +108 @@
-CMD_MYSQLDUMP = /usr/bin/mysqldump
-
+DATABASE_UTF8 = yes
+
-#
-# Main variables

trunk/gui/include/sql.php

@@ -37 +37 @@
-@$sql -> Connect($cfg['DB_HOST'], $cfg['DB_USER'], $cfg['DB_PASS'], $cfg['DB_NAME']) OR
-        system_message('ERROR: Unable to connect to SQL server !<br>SQL returned: '.$sql -> ErrorMsg() );
+
+/* switch optionally to utf8 based communication with the database */
+if (isset($cfg['DATABASE_UTF8']) && $cfg['DATABASE_UTF8'] == 'yes') {
+ @$sql->Execute("SET NAMES 'utf8'");
+}
-
-/* No longer needed */