Hi!
psqlODBC 7.02.0002 + PostgreSql 7.2.1 + Borland BDE + Windows95.
ODBC behaves very strangely for bytea:
create table MyTable (c1 integer,c2 bytea);
--Then fill up value2 with blob value using Borland Delphi.
INSERT INTO MyTable VALUES(:value1,:value2)
The inserted row is really odd - c2 contains the OID pointing to the blob data. Though I don't know where the blob
dataactually reside, lo_export command does export the blob data to Linux file system. The even more serious problem I
cannotcircumvent is that I don't know how to retrieve that blob data from PostgreSQl through psqlODBC. This is because
psqlODBCseems to not be able to return blob field type for BDE.
Thus, I am trying to use TEXT column instead - and fail, too:
create table MyTable (c1 integer,c2 text);
--Then fill up value2 with string value using Delphi.
INSERT INTO MyTable VALUES(:value1,:value2)
The INSERT results in Access Violation from IODBC32.DLL.
Please note that value2 is about 55 kbytes in size and contains some low values, '\0' in terms of C. Can this be the
problemconfusing pgsqlODBC?
I am in dilemma. Please help!
CN
--
_______________________________________________
Get your free email from http://www.graffiti.net
Powered by Outblaze
