#34651 [Opn->Fbk]: can't read unicode chars from access file
| From: | derick@php.net | Date: | Tue, 27 Sep 2005 07:05:55 +0000 |
| Subject: | #34651 [Opn->Fbk]: can't read unicode chars from access file | ||
| References: | 1 | Groups: | php.bugs |
| Request: | Send a blank email to php-bugs+get-85628@lists.php.net to get a copy of this message | ||
ID: 34651
Updated by: derick@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:
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.
Previous Comments:
------------------------------------------------------------------------
[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