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:
View Add Comment Developer Edit
Welcome! If you don't have a Git account, you can't do anything here.
You can add a comment by following this link or if you reported this bug, you can edit this bug over here.
(description)
Block user comment
Status: Assign to:
Package:
Bug Type:
Summary:
From: charles dot w dot buege at temeda dot com
New email:
PHP Version: OS:

 

 [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