Bug #68271 [Opn->Fbk]: 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: adambaratz@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: Open +Status: Feedback Type: Bug -Package: PDO related +Package: PDO DBlib Operating System: CentOS 6.5 x64 PHP Version: 5.5.18 Block user comment: N Private report: N New Comment: Could you give full example code, including DB schema? Previous Comments: ------------------------------------------------------------------------ [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