Bug #68271 [NEW]: Cannot retrieve an XML field from an MSSQL table without a 'Convert'

From: charles dot w dot buege at temeda dot com Operating system: CentOS 6.5 x64 PHP version: 5.5.18 Package: PDO related Bug Type: Bug Bug description:Cannot retrieve an XML field from an MSSQL table without a 'Convert' 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 bug report at https://bugs.php.net/bug.php?id=68271&edit=1 -- Try a snapshot (PHP 5.4): https://bugs.php.net/fix.php?id=68271&r=trysnapshot54 Try a snapshot (PHP 5.5): https://bugs.php.net/fix.php?id=68271&r=trysnapshot55 Try a snapshot (trunk): https://bugs.php.net/fix.php?id=68271&r=trysnapshottrunk Fixed in SVN: https://bugs.php.net/fix.php?id=68271&r=fixed Fixed in release: https://bugs.php.net/fix.php?id=68271&r=alreadyfixed Need backtrace: https://bugs.php.net/fix.php?id=68271&r=needtrace Need Reproduce Script: https://bugs.php.net/fix.php?id=68271&r=needscript Try newer version: https://bugs.php.net/fix.php?id=68271&r=oldversion Not developer issue: https://bugs.php.net/fix.php?id=68271&r=support Expected behavior: https://bugs.php.net/fix.php?id=68271&r=notwrong Not enough info: https://bugs.php.net/fix.php?id=68271&r=notenoughinfo Submitted twice: https://bugs.php.net/fix.php?id=68271&r=submittedtwice register_globals: https://bugs.php.net/fix.php?id=68271&r=globals PHP 4 support discontinued: https://bugs.php.net/fix.php?id=68271&r=php4 Daylight Savings: https://bugs.php.net/fix.php?id=68271&r=dst IIS Stability: https://bugs.php.net/fix.php?id=68271&r=isapi Install GNU Sed: https://bugs.php.net/fix.php?id=68271&r=gnused Floating point limitations: https://bugs.php.net/fix.php?id=68271&r=float No Zend Extensions: https://bugs.php.net/fix.php?id=68271&r=nozend MySQL Configuration Error: https://bugs.php.net/fix.php?id=68271&r=mysqlcfg