Skip site navigation (1) Skip section navigation (2)

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

From: ranjeeth kumar <ranjeeth_cool(at)yahoo(dot)co(dot)in>
To: Hiroshi Saito <hiroshi(at)winpg(dot)jp>
Cc: "pgsql-odbc(at)postgresql(dot)org" <pgsql-odbc(at)postgresql(dot)org>
Subject: Re: Regarding PostgreSQL BIT datatype binding in ODBC.......
Date: 2012-09-10 15:17:45
Message-ID: 1347290265.7494.YahooMailNeo@web190001.mail.sg3.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-odbc
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.

In response to

Responses

pgsql-odbc by date

Next:From: Petr PateraDate: 2012-09-11 11:00:53
Subject: ODBC 64bit + SSL
Previous:From: Hiroshi SaitoDate: 2012-09-10 14:31:27
Subject: Re: Regarding PostgreSQL BIT datatype binding in ODBC.......

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group