Re: Max LongVarChar

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/