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 22:27:42
Message-ID: 4F88A85E.6070104@tpf.co.jp (view raw or flat)
Thread:
Lists: pgsql-odbc
(2012/04/14 3:00), Barry Bell wrote:
> 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.

Could you send me the Mylog output?
You can take the log by adding Debug=1; in your connection string.

regards,
Hiroshi Inoue

In response to

pgsql-odbc by date

Next:From: Jan-Peter SeifertDate: 2012-04-23 11:21:59
Subject: Advanced Options - OID
Previous:From: Barry BellDate: 2012-04-13 18:00:12
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