Skip site navigation (1) Skip section navigation (2)

Re: ODBC interface question

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 (view raw or flat)
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

In response to

pgsql-odbc by date

Next:From: Denis GasparinDate: 2001-09-10 08:10:01
Subject: Primary keys and ODBC/Microsoft Access
Previous:From: Jim DickensonDate: 2001-09-09 15:40:19
Subject: ODBC interface question

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group