Re: int8 becames string in BDE :-(

From: Kovacs Zoltan <kovacsz(at)pc10(dot)radnoti-szeged(dot)sulinet(dot)hu>
To: Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)jp>
Cc: tgl(at)sss(dot)pgh(dot)pa(dot)us, pgsql-odbc(at)postgresql(dot)org
Subject: Re: int8 becames string in BDE :-(
Date: 2002-05-29 07:01:54
Message-ID: Pine.LNX.4.21.0205290856150.17747-100000@pc10.radnoti-szeged.sulinet.hu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

On Wed, 29 May 2002, Hiroshi Inoue wrote:

> Kovacs Zoltan wrote:
> >
> > Dear Hiroshi and Tom,
> >
> > I downloaded the latest psqlodbc.dll for PostgreSQL 7.2.1.
> > My problem is I
> > should migrate from 7.1.3 to 7.2.1 because I need "CREATE OR REPLACE
> > FUNCTION", but COUNT(*) returns int8 now. Unfortunately,
> > Borland Database
> > Engine and/or ODBCExpress (from Korbitec Pty.) understands
> > int8 as string.
>
> Is it the true cause ?
> Isn't it because of the current driver's behavior that
> returns SQL_VARCHAR for int8 ? OTOH certainly there are
> some applications which can't handle SQL_BIGINT.
> Recently I changed the driver to return SQL_NUMERIC
> for int8 with Microsoft-jet and it seems to work.

Where can I check for the setting? Can I adjust it in the "Driver" menu?
I'm using version 07_02_0001, announced on 15th April.

Thanks, Zoltan

--
Kov\'acs, Zolt\'an
kovacsz(at)pc10(dot)radnoti-szeged(dot)sulinet(dot)hu
http://www.math.u-szeged.hu/~kovzol
ftp://pc10.radnoti-szeged.sulinet.hu/home/kovacsz

In response to

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Laszlo Tibor 2002-05-29 15:41:12 Re: int8 becames string in BDE :-(
Previous Message Hiroshi Inoue 2002-05-29 02:30:18 Re: md5 with psqlODBC 07.02.0001?