in reply to SQL Server CAST problem using CASE with DBD::ODBC
Given "Invalid character value for cast specification" and that it works when not using Perl, I'd guess "\t" or "\r" is the problem. Seems unlikely. You should probably also dump (for example, using Data::Dumper) the string to make sure there aren't more unusual characters in there that you aren't seeing.
- tye
|
|---|