Re: Max LongVarChar - Mailing list pgsql-odbc

From Hiroshi Inoue
Subject Re: Max LongVarChar
Date
Msg-id 3DFE7079.6D4A2028@tpf.co.jp
Whole thread Raw
In response to Max LongVarChar  ("Bruce Holt" <bj_holt@hotmail.com>)
List pgsql-odbc
Bruce Holt wrote:
>
>   What is the maximum value for 'Max LongVarChar' within the
>   ODBC Advanced Options (DSN 1/2) dialog box?

There's no max value because the driver itself doesn't
provide any buffer beforehand with the MaxLongVarChar size.
However, most applications seem to have their own text
size limitations.

> What affect does this setting have on
> performance?

It depends on your application. If your application
binds a text item with the MaxLongVarChar sized buffer
,it may unnecessarily consume a large memory.

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

pgsql-odbc by date:

Previous
From: Hiroshi Inoue
Date:
Subject: Re: Problem with table name in capitals.
Next
From: srihari
Date:
Subject: Kylix-postgreSQL connectivity