|
php.net | support | documentation | report a bug | advanced search | search howto | statistics | random bug | login |
PatchesPull RequestsHistoryAllCommentsChangesGit/SVN commits
[2009-04-25 15:09 UTC] jani@php.net
[2009-05-03 01:00 UTC] php-bugs at lists dot php dot net
|
|||||||||||||||||||||||||||||||||||||
Copyright © 2001-2025 The PHP GroupAll rights reserved. |
Last updated: Wed Dec 17 23:00:01 2025 UTC |
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.