data type conversion ?
От | Cherubini Enrico |
---|---|
Тема | data type conversion ? |
Дата | |
Msg-id | 20021120141024.GA28464@bestkevin.com обсуждение исходный текст |
Список | 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
В списке pgsql-odbc по дате отправления: