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).