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

Re: How can I bind query parameters to variables ?

From: Timothy Madden <terminatorul(at)gmail(dot)com>
To: Rainer Bauer <usenet(at)munnin(dot)com>
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: How can I bind query parameters to variables ?
Date: 2009-05-20 09:28:50
Message-ID: 5078d8af0905200228t549baf77u6955356a3ac7a583@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-odbc
On Tue, May 19, 2009 at 7:43 PM, Rainer Bauer <usenet(at)munnin(dot)com> wrote:
> Hello Timothy,
>
> TM> Still the problem is I could not use Large Object data type in
> TM> ODBC to insert values in my BIT VARYING column. It said the
> TM> parameter is of type lo, which I created as in the how-to, but the
> TM> columns is BIT VARYING. Using CAST() on the parameter did not
> TM> help. :(
>
> I don't think you will ever be happy if you try to use a bit field to
> store binary data. Use bytea [1] instead (the 'lo' type has the
> disadvantage the the data is not stored inside the table).
>
> Note that the support for BIT VARYING was dropped in SQL:2003 [2].
> SQL:2003 has the BLOB datatype to store binary data and SQL:2008 will
> have 2 new types: BINARY and BINARY VARYING.

So now I am left with no standard way of using binary data în PostgreSQL :(.

I guess I will have to stick to VARBIT until better times ...

Thank you,
Timothy Madden

In response to

pgsql-odbc by date

Next:From: Timothy MaddenDate: 2009-05-20 09:47:13
Subject: Re: How to transfer binary data into a BIT VARYING column ?
Previous:From: Tom LaneDate: 2009-05-19 23:05:40
Subject: Re: Can't connect Win XP client to Linux server

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