Re: ODBC Error

Jillian,

> When I insert content from my WYSIWYG editor (eWebEditPro by Ektron)
> I
> sometimes receive the following error.  I don't believe the problem
> to be
> ColdFusion related, as the problem cannot be replicated on MySQL
> (which I'd
> really rather not have to use).  I'm using Postgresql on RedHat.  The
> datatype is text, which I know is virtually unlimited.  Anybody have
> this
> happen before?  I've also posted the CFQUERY from action.cfm below
> this
> error.

No, it's ODBC related.  Most ODBC drivers regognize TEXT as
VARCHAR(1000 or 5000), and give you errors when you pass a longer
string.  Worse ODBC drivers have an absolute limit on the length of
query strings ... for example, ADO-ODBC for VB 6.0 cut you off at 8000
chars total, as I recall.

Remember that when the ODBC standard was written, several databases had
a length limit of *48 characters* on text fields.   So really long text
fields have been a chronic problem of legacy bugs.

What ODBC driver are you using?  Where did it come from?  What's your
client platform (NT or Linux?)   Figure out the specifics, and then
re-post your question to the mailing list for the PGAdmin project
(pgadmin.postgresql.org) who I believe are the current ODBC
maintainers.

Keep in mind that, if your ODBC client is supplied by ColdFusion,
  you'll have to take it up with them.

-Josh Berkus