Skip Menu |

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

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

People
Owner: Nobody in particular
Requestors: milu71 [...] googlemail.com
Cc:
AdminCc:

Bug Information
Severity: Normal
Broken in: 1.23
Fixed in: 1.24_6



Subject: XML type not known to DBD::ODBC as Unicode type
The XML column typically receives Unicode input, and hence should be bound by default to SQL_WCHAR in order for the user not to have to specify it manually by calling (accuracy of the following not verified): $sth->bind_param( $num_of_col, $val_of_col, {TYPE => DBI::SQL_WCHAR} ); That statement should work (but doesn't do so with DBD::ODBC 1.23 against SQL Server Native Client 10.0 on Windows XP Home SP3).
On Wed Sep 15 16:07:16 2010, MiLu wrote: Show quoted text
> The XML column typically receives Unicode input, and hence should be > bound by default to SQL_WCHAR in order for the user not to have to > specify it manually by calling (accuracy of the following not verified): > > $sth->bind_param( $num_of_col, $val_of_col, {TYPE => DBI::SQL_WCHAR} ); > > That statement should work (but doesn't do so with DBD::ODBC 1.23 > against SQL Server Native Client 10.0 on Windows XP Home SP3).
This is fixed in 1.24_6 and 1.25. Martin -- Martin J. Evans Wetherby, UK