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  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 .
SQL:2003 has the BLOB datatype to store binary data and SQL:2008 will
have 2 new types: BINARY and BINARY VARYING.
In response to
pgsql-odbc by date
|Next:||From: Geoff Lane||Date: 2009-05-19 19:48:31|
|Subject: Can't connect Win XP client to Linux server|
|Previous:||From: Tom Lane||Date: 2009-05-19 15:18:31|
|Subject: Re: How to transfer binary data into a BIT VARYING column ? |