Re: Adding long text to a text field generates an error

> "Text" in this context refers to the PostgreSQL
> datatype "text". Whether the setting matters depends
> on whether "text" is what you are using, and on what
> LongVarChar maps to in your environment. For example,
> in MS Access it maps to "memo", which has limitations
> (e.g. cannot be included in the where clause of a
> query).
>
> I think better just to up the number. Pick a big
> number, and see what happens. While you are at it, up
> the Max VarChar setting, too.

Well, I am using the PostgreSQL datatype "text" in this context, so that
should work. Also, why should I raise Max VarChar over the default
varchar setting of 255?

I guess what I'll do is just play around with it as someone suggested.
I really didn't know those settings were there until you asked me to
post the ODBC driver settings. I had completely overlooked them.

Thanks a bunch!

-Ben