Re: Regarding PostgreSQL BIT datatype binding in ODBC.......

Hi.

Umm,
It can check in this simple test code.

Regards,
Hiroshi Saito

(2012/09/11 0:17), ranjeeth kumar wrote:
> Hello Saito,
>
> Thanks a lot for your response.
> I tried using SQL_C_TCHAR and SQL_CHAR as you suggested but I still get
> the same "Incorrect binary data format in bind parameter" error.
> I am not sure if I am missing something here...
>
>
> Thanks and Regards,
> Ranjeeth.
>
>
> ------------------------------------------------------------------------
> *From:* Hiroshi Saito <hiroshi@winpg.jp>
> *To:* ranjeeth kumar <ranjeeth_cool@yahoo.co.in>
> *Cc:* "pgsql-odbc@postgresql.org" <pgsql-odbc@postgresql.org>
> *Sent:* Monday, 10 September 2012 8:01 PM
> *Subject:* Re: [ODBC] Regarding PostgreSQL BIT datatype binding in
> ODBC.......
>
> Hi.
>
> Is this helpful to you?
> one example)
> == odbc
> SQLTCHAR kd[100];
> strcpy(kd, "1101010101");
> ...
> SQLPrepare(hstmt, "INSERT INTO bbb VALUES (?)", SQL_NTS);
> SQLBindParameter(hstmt, (SQLUSMALLINT)1, SQL_PARAM_INPUT,
> SQL_C_TCHAR, SQL_CHAR, 0, 0, &kd[0], 100, &len);
> == psql
> postgres=# select * from bbb;
> key
> ------------
> 1101010101
>
> Regards,
> Hiroshi Saito
>
> (2012/09/10 13:32), ranjeeth kumar wrote:
>  > Hello All,
>  >
>  > I have a table with a bit(10) type colmn. I can insert "1010110110" into
>  > that column from PSQL.
>  > i.e.,
>  > postgres=# insert into public.ranc2b values(1,'1101010101');
>  > INSERT 0 1
>  >
>  > I want to insert the same character data "1010110110" into the same
>  > bit(10) typed column from an ODBC application program,
>  > Can somebody please suggest me how should I bind the data in the
>  > SQLBindParameter call.
>  >
>  > I tried to bind the data as SQL_BINARY and SQL_CHAR but I got Incorrect
>  > binary data format error.
>  >
>  > Quick help is appreciated.
>  >
>  > Thanks in Advance.
>  >
>  > Regards,
>  > Ranjeeth.
>
>