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

From Jeff Eckermann
Subject Re: Adding long text to a text field generates an error
Date
Msg-id 20040119230203.70409.qmail@web20808.mail.yahoo.com
Whole thread Raw
In response to Adding long text to a text field generates an error  (Ben Ramsey <br@benandliz.com>)
Responses Re: Adding long text to a text field generates an error  (Ben Ramsey <br@benandliz.com>)
List pgsql-odbc
--- Ben Ramsey <br@benandliz.com> wrote:
> > "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 it doesn't matter if you are using the text
datatype.  AFAIK varchar(n) maps to ODBC VarChar, so
it would matter if you were using varchar(n).

>
> 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!

We haven't established that this works, yet ;-)

__________________________________
Do you Yahoo!?
Yahoo! Hotjobs: Enter the "Signing Bonus" Sweepstakes
http://hotjobs.sweepstakes.yahoo.com/signingbonus

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