#34651 [Opn->Fbk]: can't read unicode chars from access file

ID: 34651 Updated by: sniper@php.net Reported By: eser at kablonet dot com dot tr -Status: Open +Status: Feedback Bug Type: COM related Operating System: windows xp PHP Version: 5.0.5 New Comment: Please try using this CVS snapshot: http://snaps.php.net/php5-latest.tar.gz For Windows: http://snaps.php.net/win32/php5-win32-latest.zip Previous Comments: ------------------------------------------------------------------------ [2005-09-27 10:07:39] eser at kablonet dot com dot tr The problem is simple, i have an access db with containing crotian chars and i can't get them, they're displayed as english chars. ------------------------------------------------------------------------ [2005-09-27 09:05:53] derick@php.net Not enough information was provided for us to be able to handle this bug. Please re-read the instructions at http://bugs.php.net/how-to-report.php If you can provide more information, feel free to add it to this bug and change the status back to "Open". Thank you for your interest in PHP. ------------------------------------------------------------------------ [2005-09-27 00:37:57] eser at kablonet dot com dot tr 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 this bug report at http://bugs.php.net/?id=34651&edit=1