php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #68271 Cannot retrieve an XML field from an MSSQL table without a 'Convert'
Submitted: 2014-10-20 17:52 UTC Modified: -
From: charles dot w dot buege at temeda dot com Assigned:
Status: Open Package: PDO related
PHP Version: 5.5.18 OS: CentOS 6.5 x64
Private report: No CVE-ID:
Have you experienced this issue?
Rate the importance of this bug to you:

 [2014-10-20 17:52 UTC] 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.


Patches

Add a Patch

Pull Requests

Add a Pull Request

 
PHP Copyright © 2001-2017 The PHP Group
All rights reserved.
Last updated: Fri Feb 24 19:01:40 2017 UTC