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        

  • Comment on Re: SQL Server CAST problem using CASE with DBD::ODBC (invisible)