From: | Cherubini Enrico <kevin(at)bestkevin(dot)com> |
---|---|
To: | pgsql-odbc(at)postgresql(dot)org |
Subject: | data type conversion ? |
Date: | 2002-11-20 14:10:24 |
Message-ID: | 20021120141024.GA28464@bestkevin.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Bo?ena Potempa | 2002-11-20 16:48:42 | Re: PostgreSQL+ Beta bug? |
Previous Message | Spraveen | 2002-11-20 10:44:13 | Regarding support for psqlodbc-7.2.3 tar |