Skip Menu |
 
rt.cpan.org will be shut down on March 1st, 2021.

This queue is for tickets about the DBD-ODBC CPAN distribution.

Report information
The Basics
Id: 59621
Status: resolved
Priority: 0/
Queue: DBD-ODBC

People
Owner: Nobody in particular
Requestors: bohica [...] ntlworld.com
Cc:
AdminCc:

Bug Information
Severity: (no value)
Broken in: 1.24
Fixed in: 1.24_2



Subject: Does not handle MS SQL Server xml columns properly
MIME-Version: 1.0
Content-Type: text/plain; charset="UTF-8"
X-Mailer: MIME-tools 5.427 (Entity 5.427)
Content-Disposition: inline
Content-Transfer-Encoding: binary
X-RT-Original-Encoding: utf-8
Content-Length: 1031
create table mje (a int primary key, b xml); insert into mje values (1, '<xx>zzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzz</xx>'); select * from mje On Windows with the original MS ODBC Driver you will data truncation errors because the column type is reported as SQL_WLONGVARCHAR (and a display size of 1073741823) and this gets restricted to LongReadLen by default. - OK On Windows with the MS native client driver you get data truncation errors too but for the wrong reason. The column type is reported -152 (which DBD::ODBC does not know) and a column size of 0. DBD::ODBC adds 1 (for the trailing nul) and attempts to bind the xml type with a buffer of 1. Changing LongReadLen does not fix this. A similar issue happens on non-Windows platforms where the column is reported as type -152 (xml). Martin -- Martin J. Evans Wetherby, UK
MIME-Version: 1.0
X-Mailer: MIME-tools 5.427 (Entity 5.427)
Content-Disposition: inline
Content-Type: text/plain; charset="UTF-8"
Message-ID: <rt-3.8.HEAD-2369-1279909286-1347.59621-0-0 [...] rt.cpan.org>
Content-Transfer-Encoding: binary
X-RT-Original-Encoding: utf-8
Content-Length: 65
This is fixed in 1.24_2. Martin -- Martin J. Evans Wetherby, UK


This service is sponsored and maintained by Best Practical Solutions and runs on Perl.org infrastructure.

Please report any issues with rt.cpan.org to rt-cpan-admin@bestpractical.com.