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

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

pgsql-odbc by date

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

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