#40150 [Opn]: PDO::ODBC Multiple byte letter is destroyed.
| From: | chores at jp1 dot cx | Date: | Sat, 17 Feb 2007 11:43:28 +0000 |
| Subject: | #40150 [Opn]: PDO::ODBC Multiple byte letter is destroyed. | ||
| References: | 1 | Groups: | php.bugs |
| Request: | Send a blank email to php-bugs+get-109058@lists.php.net to get a copy of this message | ||
ID: 40150
User updated by: chores at jp1 dot cx
Reported By: chores at jp1 dot cx
Status: Open
Bug Type: PDO related
Operating System: Windows Server 2003
-PHP Version: 5.2.0
+PHP Version: 5.2.1
New Comment:
PHP 5.2.1 non-FIX
Previous Comments:
------------------------------------------------------------------------
[2007-01-22 16:45:16] chores at jp1 dot cx
table(top), expected(center) and actual results(lower part):
-----------------------------------------------------------
http://test.jp1.cx/php_bugs/40150.png
------------------------------------------------------------------------
[2007-01-17 16:17:30] tony2001@php.net
Please do not forget about expected and actual results.
------------------------------------------------------------------------
[2007-01-17 16:12:34] chores at jp1 dot cx
Source:
-------
<?php
mb_internal_encoding('Shift_JIS');
$fn_db = mb_convert_encoding('//xxx/xx/xxx/xxx.mdb', 'SJIS');
$dbh = new PDO("odbc:Driver={Microsoft Access Driver
(*.mdb)};Dbq=$fn_db;Uid=Admin");
$sql = 'SELECT [t].c FROM [t]';
$cursor = $dbh->query($sql);
writeTableOneRowByPDOStatement($cursor);
while ($col_row = $cursor ->fetch(PDO::FETCH_ASSOC,NULL,1)) {
foreach ($col_row as $col_name => $val) {
echo "$col_name => $val<br>\n";
}
}
?>
------------------------------------------------------------------------
[2007-01-17 08:22:04] tony2001@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.
------------------------------------------------------------------------
[2007-01-16 23:28:47] chores at jp1 dot cx
Description:
------------
Multiple byte letter is destroyed with SELECT.
As for database .mdb. By way of ODBC.
Sentence end is destroyed.
The air which processes the place where it should process at the number
of letters, at the number of bytes does.
(It translated this sentence with
http://translate.google.com/translate_t.)
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=40150&edit=1
