From dd90eefae18d75db703bc3d2ebd21501f12d3213 Mon Sep 17 00:00:00 2001 From: Andrew Dolgov Date: Fri, 1 Dec 2017 22:14:54 +0300 Subject: [PATCH] PDO: set unicode for mysql and other connection params --- classes/db.php | 15 +++++++++++++++ 1 file changed, 15 insertions(+) diff --git a/classes/db.php b/classes/db.php index 94dec766..aba249a5 100644 --- a/classes/db.php +++ b/classes/db.php @@ -38,6 +38,21 @@ class Db implements IDb { exit(101); } + if (DB_TYPE == "pgsql") { + + $this->pdo->query("set client_encoding = 'UTF-8'"); + $this->pdo->query("set datestyle = 'ISO, european'"); + $this->pdo->query("set TIME ZONE 0"); + $this->pdo->query("set cpu_tuple_cost = 0.5"); + + } else if (DB_TYPE == "mysql") { + $this->pdo->query("SET time_zone = '+0:0'"); + + if (defined('MYSQL_CHARSET') && MYSQL_CHARSET) { + $this->pdo->query("SET NAMES " . MYSQL_CHARSET); + } + } + $this->link = $this->adapter->connect(DB_HOST, DB_USER, DB_PASS, DB_NAME, defined('DB_PORT') ? DB_PORT : ""); if (!$this->link) { -- 2.39.5