Bug #71928 [NEW]: Charset in DSN for Interbase/Firefox not working
From: b dot vonheesen at maprom dot de
Operating system: Ubuntu 14.04 LTS 64-Bit
PHP version: 7.0.4
Package: PDO Firebird
Bug Type: Bug
Bug description:Charset in DSN for Interbase/Firefox not working
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 bug report at https://bugs.php.net/bug.php?id=71928&edit=1
--
Try a snapshot (PHP 5.4): https://bugs.php.net/fix.php?id=71928&r=trysnapshot54
Try a snapshot (PHP 5.5): https://bugs.php.net/fix.php?id=71928&r=trysnapshot55
Try a snapshot (trunk): https://bugs.php.net/fix.php?id=71928&r=trysnapshottrunk
Fixed in SVN: https://bugs.php.net/fix.php?id=71928&r=fixed
Fixed in release: https://bugs.php.net/fix.php?id=71928&r=alreadyfixed
Need backtrace: https://bugs.php.net/fix.php?id=71928&r=needtrace
Need Reproduce Script: https://bugs.php.net/fix.php?id=71928&r=needscript
Try newer version: https://bugs.php.net/fix.php?id=71928&r=oldversion
Not developer issue: https://bugs.php.net/fix.php?id=71928&r=support
Expected behavior: https://bugs.php.net/fix.php?id=71928&r=notwrong
Not enough info: https://bugs.php.net/fix.php?id=71928&r=notenoughinfo
Submitted twice: https://bugs.php.net/fix.php?id=71928&r=submittedtwice
register_globals: https://bugs.php.net/fix.php?id=71928&r=globals
PHP 4 support discontinued: https://bugs.php.net/fix.php?id=71928&r=php4
Daylight Savings: https://bugs.php.net/fix.php?id=71928&r=dst
IIS Stability: https://bugs.php.net/fix.php?id=71928&r=isapi
Install GNU Sed: https://bugs.php.net/fix.php?id=71928&r=gnused
Floating point limitations: https://bugs.php.net/fix.php?id=71928&r=float
No Zend Extensions: https://bugs.php.net/fix.php?id=71928&r=nozend
MySQL Configuration Error: https://bugs.php.net/fix.php?id=71928&r=mysqlcfg
Thread (2 messages)
- b dot vonheesen at maprom dot de