Postgres Pro
Downloads
Home   >   mailing lists

Re: Passing numeric Bind variables to ODBC driver convers to "Double precision" - Mailing list pgsql-odbc

From Hiroshi Inoue
Subject Re: Passing numeric Bind variables to ODBC driver convers to "Double precision"
Date
Msg-id 4F8829A9.4000500@tpf.co.jp
Whole thread Raw
In response to Re: Passing numeric Bind variables to ODBC driver convers to "Double precision"  (Barry Bell <Barry_Bell@harte-hanks.com>)
Responses Re: Passing numeric Bind variables to ODBC driver convers to "Double precision"  (Barry Bell <Barry_Bell@harte-hanks.com>)
List pgsql-odbc
Tree view 
(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

pgsql-odbc by date:

Previous
From: Barry Bell
Date:
Subject: Re: Passing numeric Bind variables to ODBC driver convers to "Double precision"
Next
From: Richard Broersma
Date:
Subject: Re: UPDATE table via ODBC fails.