Postgres Pro
Downloads
Home   >   mailing lists

Issue of Varchar(225) converted to Long datatype by PostGreODBC(Ansi) driver - Mailing list pgsql-odbc

From vidisha.shah@tcs.com
Subject Issue of Varchar(225) converted to Long datatype by PostGreODBC(Ansi) driver
Date
Msg-id OF673E38B2.6413BBB7-ON6525715B.001E175E-6525715B.001EB42C@tcs.com
Whole thread Raw
Responses Re: Issue of Varchar(225) converted to Long datatype by PostGreODBC(Ansi) driver  (Ludek Finstrle <luf@pzkagis.cz>)
List pgsql-odbc
Tree view

Hi

I am using the PostgreODBC(Ansi Driver).

when I describe the source table, varchar(255) datatype is converted into Long datatype..

In one table I have two fields (say c1 and c2) which are varchar(255) in Source Postgre System.they both are converted into Long.Due to which I can not query those two fields simultaneously in my select qyery.

select c1 from table - works fine
select c2 from table - works fine
select c1,c2 from table - does not work

I have to query source table and insert data in Oracle Table.

Can anyone suggest workaround for this?

Thanks & Regards

Vidisha B Shah
Tata Consultancy Services Limited
Mailto: vidisha.shah@tcs.com
Website: http://www.tcs.com
=====-----=====-----=====
Notice: The information contained in this e-mail 
message and/or attachments to it may contain 
confidential or privileged information. If you are 
not the intended recipient, any dissemination, use, 
review, distribution, printing or copying of the 
information contained in this e-mail message 
and/or attachments to it are strictly prohibited. If 
you have received this communication in error, 
please notify us by reply e-mail or telephone and 
immediately and permanently delete the message 
and any attachments. Thank you

pgsql-odbc by date:

Previous
From: "Andrew Ng"
Date:
Subject: Re: Support for PostgreSQL 8.1.3 stable
Next
From: Ludek Finstrle
Date:
Subject: Re: odbc 8.01.02 8190 bytes limitation