Re: Adding long text to a text field generates an error - Mailing list pgsql-odbc

From Ben Ramsey
Subject Re: Adding long text to a text field generates an error
Date
Msg-id 400C5CBA.7030802@benandliz.com
Whole thread Raw
In response to Re: Adding long text to a text field generates an error  (Jeff Eckermann <jeff_eckermann@yahoo.com>)
List pgsql-odbc
> "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

pgsql-odbc by date:

Previous
From: Jeff Eckermann
Date:
Subject: Re: Adding long text to a text field generates an error
Next
From: Ben Ramsey
Date:
Subject: Re: Adding long text to a text field generates an error