From: | Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)jp> |
---|---|
To: | Jim Dickenson <dickenson(at)cfmc(dot)com> |
Cc: | pgsql-odbc(at)postgresql(dot)org |
Subject: | Re: ODBC interface question |
Date: | 2001-09-10 04:02:55 |
Message-ID: | 3B9C3B6F.26B8C1F9@tpf.co.jp |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Denis Gasparin | 2001-09-10 08:10:01 | Primary keys and ODBC/Microsoft Access |
Previous Message | Jim Dickenson | 2001-09-09 15:40:19 | ODBC interface question |