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 400C0D17.9000809@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>)
Responses Re: Adding long text to a text field generates an error  (Jeff Eckermann <jeff_eckermann@yahoo.com>)
List pgsql-odbc
 > Please post your ODBC driver settings.  The table
 > definitions and the sql you are using may be helpful
 > also.

I was ready to post my code and table definition and everything, and
then I opened up the driver settings for the DSN that connects to the
database, clicked on the "Datasource" options button, which launched a
window with all sorts of options.  Here's what I found:

"Text as LongVarChar" is checked.
"Max LongVarChar" is set to 8190.

Should I uncheck "Text as LongVarChar"?  What will it do if I uncheck
it?  If I shouldn't uncheck it, then what should I set "Max LongVarChar"
to in order to allow unlimited amounts of text?

-Ben

pgsql-odbc by date:

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