Hi,
I just installed, after a long time, the odbc driver to test accessing to a
postgresql db on my debian woody box. Well, my need is to access it from a
program that is designed to use other DB, like sybase, M$ sql server and so
on...the program is closesd source, so I cannot modify it. The first impact
was "bad, I cannot access it" but looking at the queries I noticed that the
problem of the error in some table creations, are caused by different name
of data type (or unimplemented). Ie...I get:
create table AZIENDA ( ....., LOGO_AZIENDA lo(4), ...)
this is using the procedure that suppose M$ sql server backend, and:
create table AZIENDA ( ....., LOGO_AZIENDA long varbinary)
if using the DB2/400 procedure
Well..I suppose this field should keep a binary information, but, more
generally, shouldn't be nice a way to translate such data type in such a way
that can be keeped by postgresql ? On the fly by the odbc driver, before
sending the query to the db...It should be a nice option where frontend are
not designed to use postgresql.
Thanks for your attention.
--
Bye Enrico - Le finestre sono spiragli di finta liberta'. Scegli Linux.
sì che per sua dottrina fe disgiunto
da l'anima il possibile intelletto,
perche da lui non vide organo assunto.
-- Purgatorio, Canto XXV, vv.64-66