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(at)winpg(dot)jp>
> *To:* ranjeeth kumar <ranjeeth_cool(at)yahoo(dot)co(dot)in>
> *Cc:* "pgsql-odbc(at)postgresql(dot)org" <pgsql-odbc(at)postgresql(dot)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.
>
>