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

Re: Passing numeric Bind variables to ODBC driver convers to "Double precision"

From: Hiroshi Inoue <inoue(at)tpf(dot)co(dot)jp>
To: Barry Bell <Barry_Bell(at)harte-hanks(dot)com>
Cc: "pgsql-odbc(at)postgresql(dot)org" <pgsql-odbc(at)postgresql(dot)org>
Subject: Re: Passing numeric Bind variables to ODBC driver convers to "Double precision"
Date: 2012-04-13 13:27:05
Message-ID: 4F8829A9.4000500@tpf.co.jp (view raw or flat)
Thread:
Lists: pgsql-odbc
(2012/04/13 2:12), Barry Bell wrote:
> Thanks, "UseServerSidePrepare=1;  does appear to fix this. (working for both numeric and integer)
>
> Next issue,
> When calling a function in postgres, the postgres is returning a blank string ('').
> This is showing as a blank longvarchar(memo,clob) instead of a varchar.
>
> Any ideas?

Please try to turn off the Text as LongVarChar option.

regards,
Hiroshi Inoue

In response to

Responses

pgsql-odbc by date

Next:From: Richard BroersmaDate: 2012-04-13 15:22:03
Subject: Re: UPDATE table via ODBC fails.
Previous:From: Barry BellDate: 2012-04-12 17:12:19
Subject: Re: Passing numeric Bind variables to ODBC driver convers to "Double precision"

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