Bug #68271 [Fbk->NoF]: Cannot retrieve an XML field from an MSSQL table without a 'Convert'

Edit report at https://bugs.php.net/bug.php?id=68271&edit=1 ID: 68271 Updated by: php-bugs@lists.php.net Reported by: charles dot w dot buege at temeda dot com Summary: Cannot retrieve an XML field from an MSSQL table without a 'Convert' -Status: Feedback +Status: No Feedback Type: Bug Package: PDO DBlib Operating System: CentOS 6.5 x64 PHP Version: 5.5.18 Private report: N New Comment: No feedback was provided. The bug is being suspended because we assume that you are no longer experiencing the problem. If this is not the case and you are able to provide the information that was requested earlier, please do so and change the status of the bug back to "Re-Opened". Thank you. Previous Comments: ------------------------------------------------------------------------ [2017-03-01 22:58:55] adambaratz@php.net Could you give full example code, including DB schema? ------------------------------------------------------------------------ [2014-10-20 17:52:00] charles dot w dot buege at temeda dot com Description: ------------ I'm attempting to retrieve some XML records (XML field type) from an SQL Server database. Whenever I try to perform 'SELECT Top 10 [Status_Info] from [MyTable]' I get a 'No records found' message, but when I change the query to this - SELECT Top 10 CONVERT(varchar(max), [Status_Info]) from [MyTable] - it works. Also, I was able to use the initial query in PHP version 5.4.25, but somewhere between 5.4.25 and 5.4.32, this bug was introduced. I have confirmed that this problem exists as well within PHP 5.6.2. I even tried PHP 5.4.33, but the problem is there also. ------------------------------------------------------------------------ -- Edit this bug report at https://bugs.php.net/bug.php?id=68271&edit=1