#34651 [NEW]: can't read unicode chars from access file

From: Date: Mon, 26 Sep 2005 22:37:59 +0000
Subject: #34651 [NEW]: can't read unicode chars from access file
Groups: php.bugs 
Request: Send a blank email to php-bugs+get-85624@lists.php.net to get a copy of this message
From: eser at kablonet dot com dot tr Operating system: windows xp PHP version: 5.0.5 PHP Bug Type: COM related Bug description: can't read unicode chars from access file Description: ------------ I'm trying to import some data from access to mysql. But i can't read crotian characters from access file. When i opened the mdb file access shows the chars correctly but php can't read them. Reproduce code: --------------- $db = 'c:\\file.mdb'; $conn = new COM('ADODB.Connection'); $conn->Open("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=$db"); $rs = $conn->Execute("select * from test"); while (!$rs->EOF): echo $rs->Fields['comment']->Value; $rs->MoveNext(); endwhile; Expected result: ---------------- Display the crotian characters. Actual result: -------------- Displays the english chars. -- Edit bug report at http://bugs.php.net/?id=34651&edit=1 -- Try a CVS snapshot (php4): http://bugs.php.net/fix.php?id=34651&r=trysnapshot4 Try a CVS snapshot (php5.0): http://bugs.php.net/fix.php?id=34651&r=trysnapshot50 Try a CVS snapshot (php5.1): http://bugs.php.net/fix.php?id=34651&r=trysnapshot51 Fixed in CVS: http://bugs.php.net/fix.php?id=34651&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=34651&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=34651&r=needtrace Need Reproduce Script: http://bugs.php.net/fix.php?id=34651&r=needscript Try newer version: http://bugs.php.net/fix.php?id=34651&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=34651&r=support Expected behavior: http://bugs.php.net/fix.php?id=34651&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=34651&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=34651&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=34651&r=globals PHP 3 support discontinued: http://bugs.php.net/fix.php?id=34651&r=php3 Daylight Savings: http://bugs.php.net/fix.php?id=34651&r=dst IIS Stability: http://bugs.php.net/fix.php?id=34651&r=isapi Install GNU Sed: http://bugs.php.net/fix.php?id=34651&r=gnused Floating point limitations: http://bugs.php.net/fix.php?id=34651&r=float No Zend Extensions: http://bugs.php.net/fix.php?id=34651&r=nozend MySQL Configuration Error: http://bugs.php.net/fix.php?id=34651&r=mysqlcfg

« previous php.bugs (#85624) next »