#36797 [NEW]: Problem using UTF-8 database with pdo_oci

From: Date: Mon, 20 Mar 2006 14:22:14 +0000
Subject: #36797 [NEW]: Problem using UTF-8 database with pdo_oci
Groups: php.bugs 
Request: Send a blank email to php-bugs+get-94634@lists.php.net to get a copy of this message 
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

Thread (12 messages)

« previous php.bugs (#94634) next »