From: | vidisha(dot)shah(at)tcs(dot)com |
---|---|
To: | pgsql-odbc(at)postgresql(dot)org |
Cc: | hemant(dot)shinde(at)tcs(dot)com, ashok(dot)poojary(at)tcs(dot)com, aleksandrs(dot)milajevs(at)ge(dot)com |
Subject: | Unable to Query the datatype varchar of PostgreSQL Server |
Date: | 2006-03-29 05:09:25 |
Message-ID: | OF6442D569.BB1DB0BA-ON65257140.001B6494-65257140.001C6B82@tcs.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-odbc |
Hi
We are trying to fetch records from Postgre Tables.
We are successfully able to build connectivity. We are Using Postgre ODBC
Driver (Unicode).
But when I query the tables of Postgre it is unable to map the datatype
varchar of source Table.
We got following Reply from Oracle Support.
---------------------------------------------------------------------------------------------------------
Hi,
.
DATA COLLECTED
===============
TRACE FILE
------------
mylog_3388.log
.
ISSUE VERIFICATION
===================
Verified the issue by the trace file mylog_3388.log, which displays
[4464]**** PGAPI_DescribeCol: res = 22422104, stmt->status = 2,
!finished=1, !premature=0
[4464]getCharColumnSize: type=1043, col=2, unknown = 0
[4464]describeCol: col 2 fieldname = 'name'
[4464]describeCol: col 2 fieldtype = 1043
[4464]describeCol: col 2 column_size = 50
[4464]getCharColumnSize: type=1043, col=2, unknown = 0
[4464]describeCol: col 2 *pfSqlType = -9
[4464]describeCol: col 2 *pcbColDef = 50
[4464]describeCol: col 2 *pibScale = 0
[4464]describeCol: col 2 *pfNullable = 1
.
CAUSE DETERMINATION
====================
VARCHAR datatype from PostgreSQL is translated by your ODBC driver in an
unsupported datatype for HSODBC.
CAUSE JUSTIFICATION
====================
In the trace file, you get the datatype from postgreSQL
====>1043 VARCHAR(50)
then you get the datatype that ODBC driver is mapping to get back to
Oracle
====>[4464]describeCol: col 2 *pfSqlType = -9
If you look at in the Note 252548.1,
-9 is SQL_WVARCHAR
and unfortunately this ODBC datatype is not supported by the Generic
Connectivity agent (HSODBC).
To get confirmation, please have a look in the documentation:
Oracle® Database Heterogeneous Connectivity Administrator's Guide
10g Release 2 (10.2)
Part Number B14232-01
B Data Type Mapping for Generic Connectivity
B.1 Mapping ANSI Data Types to Oracle Data Types Through an ODBC Interface
.
POTENTIAL SOLUTION(S)
======================
Please check if in your ODBC driver there is any option to differently map
the SQL_WVARCHAR d
atatype
-----------------------------------------------------------------------------------------------------------
Can you please suggest why varchar datatype is not correctly identified
and what is the path to get solution?
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 | vidisha.shah | 2006-03-29 05:32:19 | Issue in Mapping varchar datatype of Postgre to Oracle |
Previous Message | Larry Rosenman | 2006-03-29 04:52:08 | Re: Exposing DEFAULT_PGSOCKET_DIR via a libpq function? |
From | Date | Subject | |
---|---|---|---|
Next Message | Ludek Finstrle | 2006-03-29 08:11:03 | Re: Unable to Query the datatype varchar of PostgreSQL Server |
Previous Message | Campbell, Greg | 2006-03-28 21:53:16 | Re: psqlODBC-Driver Test / text fields |