Thread: Max LongVarChar

  What is the maximum value for 'Max LongVarChar' within the ODBC Advanced
Options (DSN 1/2) dialog box?  What affect does this setting have on
performance?

  I have a field of type 'text' that will usually contain less that the
default 8190 characters specified in the ODBC setting.  Occasionally, this
field will need to store text that could exceed a couple megabytes in size.

Thanks,
Bruce Holt



_________________________________________________________________
Add photos to your e-mail with MSN 8. Get 2 months FREE*.
http://join.msn.com/?page=features/featuredemail

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/