ID: 45463 Updated by: [email protected] Reported By: stane dot ferencak at gmail dot com -Status: Open +Status: Feedback Bug Type: PDO related Operating System: Windows XP PHP Version: 5.2.6 New Comment:
Please try using this CVS snapshot: http://snaps.php.net/php5.2-latest.tar.gz For Windows: http://windows.php.net/snapshots/ Previous Comments: ------------------------------------------------------------------------ [2008-07-09 08:49:06] stane dot ferencak at gmail dot com 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 this bug report at http://bugs.php.net/?id=45463&edit=1
