[prev in list] [next in list] [prev in thread] [next in thread] 

List:       dbi-users
Subject:    Re: Extra nulls inserted with binary data (DBD::ODBC on Win7)
From:       Jerrad Pierce <jpierce () nmrgroupinc ! com>
Date:       2016-01-28 15:51:59
Message-ID: 56AA391F.7040200 () nmrgroupinc ! com
[Download RAW message or body]

Martin has informed me that Microsoft doesn't support SQLDescribeParam and
in the absence of an explicit bind_param, miscasts the data as VARCHAR.

    $sth->bind_param(1, undef, SQL_LONGVARBINARY);

Solved the problem.

[Attachment #3 (text/html)]

<html>
  <head>
    <meta content="text/html; charset=utf-8" http-equiv="Content-Type">
  </head>
  <body bgcolor="#FFFFFF" text="#000000">
    Martin has informed me that Microsoft doesn't support
    SQLDescribeParam and<br>
    in the absence of an explicit bind_param, miscasts the data as
    VARCHAR.<br>
    <blockquote><tt>$sth-&gt;bind_param(1, undef, SQL_LONGVARBINARY);</tt><br>
    </blockquote>
    Solved the problem.<br>
  </body>
</html>


[prev in list] [next in list] [prev in thread] [next in thread]

Configure | About | News | Add a list | Sponsored by KoreLogic