Обсуждение: Specifying Max LongVarChar in odbcinst.ini doesn't work

Hi,
I am using the PostgreSQL odbc driver from the 7.2.1 release. I am able to
connect to the database fine. But, I am trying to set the limit for
longVarChar to something greater than 8190. This setting seems to be
ignored. What line should I put in $POSTGRES/etc/odbcinst.ini to increase
the size of a longvarchar column? I am using the driver without a driver
manager.

Any help is greatly appreciated!

-- Janet

Janet Borschowa wrote:
>
> Hi,
> I am using the PostgreSQL odbc driver from the 7.2.1 release.
> I am able to
> connect to the database fine. But, I am trying to set the limit for
> longVarChar to something greater than 8190. This setting seems to be
> ignored. What line should I put in $POSTGRES/etc/odbcinst.ini to

Try to put it into ~/.odbc.ini.
[Remarks]
1. The keyword is MaxLongVarcharSize (Case Sensitive).
2. You had better not use tab or space around '='.

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