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

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

From: Barry Bell <Barry_Bell(at)harte-hanks(dot)com>
To: Hiroshi Inoue <inoue(at)tpf(dot)co(dot)jp>
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 18:00:12
Message-ID: 542B943ED5D72E408BF9CBBD61ABC94D52D11168@VA3DIAXVSC31.RED001.local (view raw or flat)
Thread:
Lists: pgsql-odbc
Note: The UseServerSidePrepare=1; only works with the PostgresSQL 9.01 driver (It will not work with the 9.00 driver)

Setting TextAsLongVarchar=0 has no effect on the blanks("") comes back as longvarchar.

UnknownsAsLongVarchar=0 or UnknownsAsLongVarchar=1 has no effect on this either.


Thanks
Barry Bell, IT Department 
Office: 954-429-3771 x267 Fax: 954-281-1464 email Barry_Bell(at)harte-hanks(dot)com


-----Original Message-----
From: Hiroshi Inoue [mailto:inoue(at)tpf(dot)co(dot)jp] 
Sent: Friday, April 13, 2012 9:27 AM
To: Barry Bell
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: [ODBC] Passing numeric Bind variables to ODBC driver convers to "Double precision"

(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: Hiroshi InoueDate: 2012-04-13 22:27:42
Subject: Re: Passing numeric Bind variables to ODBC driver convers to "Double precision"
Previous:From: Richard BroersmaDate: 2012-04-13 15:22:03
Subject: Re: UPDATE table via ODBC fails.

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