Re: Problem about Bytea and SQL_C_CHAR

Please try the snapshot dll at http://w2422.nsk.ne.jp/~inoue/ .

regards,
Hiroshi Inoue
    http://w2422.nsk.ne.jp/~inoue/

Han wrote:
>
> Hi,
>         Here is the code:
>
>     strcpy(data, "FF");
>         cb = 2;
>         rc = SQLBindParameter(hstmt, i,
>                                                 SQL_PARAM_INPUT,
>                                                 SQL_C_CHAR,
>                        SQL_VARBINARY,
>                                                 precision, scale,
>                                                 &data, MAX_STRING_SIZE,
>                                                 &cb);
>         rc = SQLPrepare(hstmt, "insert into test(ColBytea) values(?)",
>         SQL_NTS);
>     rc = SQLExecute(hstmt);
>
>         After this, the value inserted in column ColByteatable
>    (datatype is bytea) of table test was a char string 'FF',
>     which was expected to be 0xFF(255).
>
>         There's no problem with binary column in Ms Sql Server.
>     I'm porting my code from sql server to postgresql. So help
>     me, please!
>