From: | vidisha(dot)shah(at)tcs(dot)com |
---|---|
To: | <pgsql-odbc(at)postgresql(dot)org> |
Subject: | Issue of Varchar(225) converted to Long datatype by PostGreODBC(Ansi) driver |
Date: | 2006-04-25 05:32:23 |
Message-ID: | OF673E38B2.6413BBB7-ON6525715B.001E175E-6525715B.001EB42C@tcs.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
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(dot)shah(at)tcs(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Ludek Finstrle | 2006-04-25 10:37:03 | Re: odbc 8.01.02 8190 bytes limitation |
Previous Message | Michael GUIARD | 2006-04-24 12:51:05 | odbc 8.01.02 8190 bytes limitation |