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