X-Git-Url: https://git.wh0rd.org/?a=blobdiff_plain;f=classes%2Fdb%2Fpdo.php;h=59499139dcc7329660a6db30dffab48ae4d06abf;hb=0e72dbd79e05c073ad5c7ed2f87866152186e092;hp=3020dea88a0c5d56063e832d0ae1c1d08252646f;hpb=9ee90455b85350e9f9cd04faf36bad8742141cd9;p=tt-rss.git

diff --git a/classes/db/pdo.php b/classes/db/pdo.php
index 3020dea8..59499139 100644
--- a/classes/db/pdo.php
+++ b/classes/db/pdo.php
@@ -3,10 +3,14 @@ class Db_PDO implements IDb {
 	private $pdo;
 
 	function connect($host, $user, $pass, $db, $port) {
-		$connstr = DB_TYPE . ":host=$host;dbname=$db;charset=utf8";
+		$connstr = DB_TYPE . ":host=$host;dbname=$db";
+
+		if (DB_TYPE == "mysql") $connstr .= ";charset=utf8";
 
 		try {
 			$this->pdo = new PDO($connstr, $user, $pass);
+			$this->pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
+			$this->init();
 		} catch (PDOException $e) {
 			die($e->getMessage());
 		}
@@ -77,5 +81,20 @@ class Db_PDO implements IDb {
 	function last_error() {
 		return join(" ", $pdo->errorInfo());
 	}
+
+	function init() {
+		switch (DB_TYPE) {
+		case "pgsql":
+			$this->query("set client_encoding = 'UTF-8'");
+			$this->query("set datestyle = 'ISO, european'");
+			$this->query("set TIME ZONE 0");
+		case "mysql":
+			$this->query("SET time_zone = '+0:0'");
+			return;
+		}
+
+		return true;
+	}
+
 }
 ?>