[freetds] Binary columns problem

Ian Ashley iashley at picdar.com
Wed Oct 6 04:23:30 EDT 2004


I am having a problem updating binary fields using SQLBindParameter. I use
the following code

char buf[6] = "\x12\x34\x56\x78\x90"

SQLPrepare(stmtHandle, ³UPDATE P_SIMPLE SET P_BINARY = ? WHERE P__URN = 1²,
SQL_NTS)
SQLBindParameter(stmtHandle, 1, SQL_PARAM_INPUT, SQL_C_BINARY, SQL_BINARY,
5, 0, buf, 0, NULL)
SQLExecute(stmtHandle)

Only the first byte of the value at buf gets stored, the remaining 4 get set
to 0.

Again any ideas. I have tried using the BufferLength and StrLen_or_IndPtr
parameters to no avail.

Thanks in advance,
Ian




More information about the FreeTDS mailing list