Re: ODBC interface question - Mailing list pgsql-odbc

From Hiroshi Inoue
Subject Re: ODBC interface question
Date
Msg-id 3B9C3B6F.26B8C1F9@tpf.co.jp
Whole thread Raw
In response to ODBC interface question  (Jim Dickenson <dickenson@cfmc.com>)
List pgsql-odbc
Jim Dickenson wrote:
>
> Your name: Jim Dickenson
> Your email address: dickenson@ cfmc.com
>
> System Configuration
> ---------------------
>   Architecture (example: Intel Pentium)Intel Pentium
>
>   Operating System (example: Linux 2.0.26 ELF): Red Hat Linux 7.1
>
>   PostgreSQL version (example: PostgreSQL-7.0):   PostgreSQL-7.0.3
>
>   Compiler used (example:  gcc 2.8.0): gcc 2.96
>
> Please enter a FULL description of your problem:
> ------------------------------------------------
> When I call SQLDescribeCol() for a column that has been defined as
> decimal(10,3) or numeric(10,3), as an example, I would expect
> the values in ColumnSizePtr and DecimalDigitsPtr to be 10 and 3,
> not 655363 and 0. Additionally I would expect DataTypePtr to be 2
> and not 12.

Hmm here I get
  ColumnSizePtr = 10
  DecimalDigitsPtr = 3
  DataTypePtr =2.
You seem be able to get the precise result using newer version
of psqlodbc driver.

regards,
Hiroshi Inoue

pgsql-odbc by date:

Previous
From: Jim Dickenson
Date:
Subject: ODBC interface question
Next
From: Denis Gasparin
Date:
Subject: Primary keys and ODBC/Microsoft Access