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

Ooops sorry, different was sended....
Please this.

(2012/09/11 22:23), Hiroshi Saito wrote:
> 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.
>>
>>
>
>
>
>