From: stane dot ferencak at gmail dot com
Operating system: Windows XP
PHP version: 5.2.6
PHP Bug Type: PDO related
Bug description: PDO fetch problem with MSSQL unicode nvarchar or ntext
Description:
------------
When reading data, stored in nvarchar or ntext type from MS SQL Database
(2000 or 2005), a special charecter is automatically inserted after 248b of
text. Type of this charecter is unknown.
This happens regardless of the way how data is inserted.
Reproduce code:
---------------
$conn_obj = new PDO ('odbc:Driver={SQL
Server};Server='.$dbserver.';Database='.$dbname.';Uid='.$dbuser.';Pwd='.$dbpass.';');
$rs_obj = $conn_obj->prepare($sql);
$rs_obj->execute();
$ln = $rs_obj->fetchAll();
print_r($ln);
Expected result:
----------------
Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Etiam sodales.
Pellentesque et metus sed sapien varius tristique. Vestibulum sagittis
porttitor leo. Aliquam sapien. Curabitur felis nisl, condimentum vel,
commodo blandit, fringilla lacinia, elit. Etiam facilisis venenatis quam.
Sed magna. Duis id risus id lacus auctor volutpat. Mauris non augue eu
lorem adipiscing vehicula. Sed blandit nibh vel nisl. Fusce semper nisi
viverra purus. Nam bibendum magna sit amet odio. Praesent id augue ac diam
tristique rutrum. Morbi interdum dictum nulla. Donec tortor nunc, tempor
vitae, tincidunt eu, varius nec, mi.
Actual result:
--------------
Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Etiam sodales.
Pellentesque et metus sed sapien varius tristique. Vestibulum sagittis
porttitor leo. Aliquam sapien. Curabitur felis nisl, condimentum vel,
commodo blandit, fringilla lacinia, elit�. Etiam facilisis venenatis
quam. Sed magna. Duis id risus id lacus auctor volutpat. Mauris non augue
eu lorem adipiscing vehicula. Sed blandit nibh vel nisl. Fusce semper nisi
viverra purus. Nam bibendum magna sit amet odio. Praesent id augue ac diam
tristique rutrum. Morbi interdum dictum nulla. Donec tortor nunc, tempor
vitae, tincidunt eu, varius nec, mi.
--
Edit bug report at http://bugs.php.net/?id=45463&edit=1
--
Try a CVS snapshot (PHP 5.2):
http://bugs.php.net/fix.php?id=45463&r=trysnapshot52
Try a CVS snapshot (PHP 5.3):
http://bugs.php.net/fix.php?id=45463&r=trysnapshot53
Try a CVS snapshot (PHP 6.0):
http://bugs.php.net/fix.php?id=45463&r=trysnapshot60
Fixed in CVS: http://bugs.php.net/fix.php?id=45463&r=fixedcvs
Fixed in release:
http://bugs.php.net/fix.php?id=45463&r=alreadyfixed
Need backtrace: http://bugs.php.net/fix.php?id=45463&r=needtrace
Need Reproduce Script: http://bugs.php.net/fix.php?id=45463&r=needscript
Try newer version: http://bugs.php.net/fix.php?id=45463&r=oldversion
Not developer issue: http://bugs.php.net/fix.php?id=45463&r=support
Expected behavior: http://bugs.php.net/fix.php?id=45463&r=notwrong
Not enough info:
http://bugs.php.net/fix.php?id=45463&r=notenoughinfo
Submitted twice:
http://bugs.php.net/fix.php?id=45463&r=submittedtwice
register_globals: http://bugs.php.net/fix.php?id=45463&r=globals
PHP 4 support discontinued: http://bugs.php.net/fix.php?id=45463&r=php4
Daylight Savings: http://bugs.php.net/fix.php?id=45463&r=dst
IIS Stability: http://bugs.php.net/fix.php?id=45463&r=isapi
Install GNU Sed: http://bugs.php.net/fix.php?id=45463&r=gnused
Floating point limitations: http://bugs.php.net/fix.php?id=45463&r=float
No Zend Extensions: http://bugs.php.net/fix.php?id=45463&r=nozend
MySQL Configuration Error: http://bugs.php.net/fix.php?id=45463&r=mysqlcfg
