in reply to Re: SQL Server SID value output as garbage using DBI
in thread SQL Server SID value output as garbage using DBI

Obviously in this case he cannot use convert as the procedure is a system defined procedure I doubt he can change.

As the current maintainer of DBD::ODBC, which I presume the OP is using, I thought you could just do "$sth->bind_col(2, undef, {TYPE => SQL_CHAR})" after the execute but it appears you cannot. If the OP wants to confirm which DBD they were using I will look into allowing a binary column's type to be overriden.

  • Comment on Re^2: SQL Server SID value output as garbage using DBI

In Section Seekers of Perl Wisdom