Beefy Boxes and Bandwidth Generously Provided by pair Networks RobOMonk
P is for Practical
 
PerlMonks  

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

by mje (Deacon)
on Jul 29, 2013 at 16:14 UTC ( #1046887=note: print w/ replies, xml ) Need Help??


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

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://1046887]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others contemplating the Monastery: (8)
As of 2014-04-20 19:00 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    April first is:







    Results (486 votes), past polls