From: mauroi at digbang dot com Operating system: Win XP SP2 PHP version: 5.1.2 PHP Bug Type: PDO related Bug description: Problem using UTF-8 database with pdo_oci
Description: ------------ I'm trying to use a AL32UTF8 database with PDO, but it seems that the charset is not correctly set (I get funny characters in the output). I've tried the method described in (http://www.oracle.com/technology/pub/articles/php_experts/otn_pdo_oracle5.html) with no success. I'm using Oracle instant client for Windows. Reproduce code: --------------- sql: create table foo (field varchar(10)); php: $a = new PDO('oci:dbname=server;charset=UTF-8', 'user', 'password'); $a->beginTransaction(); $b = $a->prepare('insert into foo (field) values (?)'); $b->bindValue(1, 'áéíóú'); $b->execute(); $c = $a->prepare('select * from foo'); $c->execute(); var_dump($c->fetchAll()); $a->rollBack(); Expected result: ---------------- the result with the row with áéíóú correctly displayed -- Edit bug report at http://bugs.php.net/?id=36797&edit=1 -- Try a CVS snapshot (PHP 4.4): http://bugs.php.net/fix.php?id=36797&r=trysnapshot44 Try a CVS snapshot (PHP 5.1): http://bugs.php.net/fix.php?id=36797&r=trysnapshot51 Try a CVS snapshot (PHP 6.0): http://bugs.php.net/fix.php?id=36797&r=trysnapshot60 Fixed in CVS: http://bugs.php.net/fix.php?id=36797&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=36797&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=36797&r=needtrace Need Reproduce Script: http://bugs.php.net/fix.php?id=36797&r=needscript Try newer version: http://bugs.php.net/fix.php?id=36797&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=36797&r=support Expected behavior: http://bugs.php.net/fix.php?id=36797&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=36797&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=36797&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=36797&r=globals PHP 3 support discontinued: http://bugs.php.net/fix.php?id=36797&r=php3 Daylight Savings: http://bugs.php.net/fix.php?id=36797&r=dst IIS Stability: http://bugs.php.net/fix.php?id=36797&r=isapi Install GNU Sed: http://bugs.php.net/fix.php?id=36797&r=gnused Floating point limitations: http://bugs.php.net/fix.php?id=36797&r=float No Zend Extensions: http://bugs.php.net/fix.php?id=36797&r=nozend MySQL Configuration Error: http://bugs.php.net/fix.php?id=36797&r=mysqlcfg