Bug #71928 [Opn->Csd]: Charset in DSN for Interbase/Firefox not working
| From: | b dot vonheesen at maprom dot de | Date: | Mon, 04 Apr 2016 12:31:01 +0000 |
| Subject: | Bug #71928 [Opn->Csd]: Charset in DSN for Interbase/Firefox not working | ||
| References: | 1 | Groups: | php.bugs |
| Request: | Send a blank email to php-bugs+get-200345@lists.php.net to get a copy of this message | ||
Edit report at https://bugs.php.net/bug.php?id=71928&edit=1
ID: 71928
User updated by: b dot vonheesen at maprom dot de
Reported by: b dot vonheesen at maprom dot de
Summary: Charset in DSN for Interbase/Firefox not working
-Status: Open
+Status: Closed
Type: Bug
Package: PDO Firebird
Operating System: Ubuntu 14.04 LTS 64-Bit
PHP Version: 7.0.4
Block user comment: N
Private report: N
New Comment:
Sorry, our Interbase server was misconfigured, now it's working.
Topic can be closed.
Previous Comments:
------------------------------------------------------------------------
[2016-03-31 06:03:16] b dot vonheesen at maprom dot de
Description:
------------
Description:
------------
Starting position:
Ubuntu 14.04 LTS 64-Bit, PHP 7.0.4
Interbase with dialect 1
If a charset is added at the end of the DSN other values will be returned by SELECT.
With old ibase_* commands it works as expected.
Test script:
---------------
$pdo1 = new PDO("firebird:dbname=......");
$stmt1 = $pdo1->query("SELECT COUNT(*) FROM mytable");
$res1 = $stmt->fetchAll();
$pdo2 = new PDO("firebird:dbname=......;charset=utf8");
$stmt2 = $pdo2->query("SELECT COUNT(*) FROM mytable");
$res2 = $stmt->fetchAll();
$pdo3 = new PDO("firebird:dbname=......;charset=UTF8");
$stmt3 = $pdo3->query("SELECT COUNT(*) FROM mytable");
$res3 = $stmt->fetchAll();
$pdo4 = new PDO("firebird:dbname=......;charset=UTF-8");
$stmt4 = $pdo3->query("SELECT COUNT(*) FROM mytable");
$res4 = $stmt->fetchAll();
$pdo5 = new PDO("firebird:dbname=......;charset=utf-8");
$stmt5 = $pdo5->query("SELECT COUNT(*) FROM mytable");
$res5 = $stmt->fetchAll();
Expected result:
----------------
$res1 = 40998
$res2 = 40998
$res3 = 40998
$res4 = 40998
$res5 = 40998
Actual result:
--------------
$res1 = 40998
$res2 = 650
$res3 = 5
$res4 = PDO-Exception "SQLSTATE[HY000] [335544325] bad parameters on attach or create
database"
$res5 = PDO-Exception "SQLSTATE[HY000] [335544325] bad parameters on attach or create
database"
------------------------------------------------------------------------
--
Edit this bug report at https://bugs.php.net/bug.php?id=71928&edit=1