Re: ODBC interface question

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