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

Re: int8 becames string in BDE :-(

From: Hiroshi Inoue <Inoue(at)tpf(dot)co(dot)jp>
To: Kovacs Zoltan <kovacsz(at)pc10(dot)radnoti-szeged(dot)sulinet(dot)hu>
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 01:45:02
Message-ID: 3CF4329E.5FAD7232@tpf.co.jp (view raw or flat)
Thread:
Lists: pgsql-odbc
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.

regards,
Hiroshi Inoue
	http://w2422.nsk.ne.jp/~inoue/

In response to

Responses

pgsql-odbc by date

Next:From: Hiroshi InoueDate: 2002-05-29 02:30:18
Subject: Re: md5 with psqlODBC 07.02.0001?
Previous:From: Kovacs ZoltanDate: 2002-05-28 18:13:11
Subject: int8 becames string in BDE :-(

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