String literal too Long error

> currently on the oracle side field sizes for the text area responses are set
> at 4000 bytes. However if a user enters anything close to that, I get a
> coldfusion error stating that the "STRING LITERAL TOO LONG".

Is the field size in bytes or characters? Are you by any chance trying to
store multi-byte character data, and counting all characters as being only
a single byte?

--
Adam

Jay, try this in your insert query:

INSERT INTO blah (SuperBigTextColumn)
values (<cfqueryparam type="CF_SQL_VARCHAR" value="#Left(FORM.SuperBigTextFromUser,3999)#">)

That'll make sure the text going in is always under 4000 chars. Alternatively...

INSERT INTO blah (SuperBigTextColumn)
values (<cfqueryparam type="CF_SQL_VARCHAR" maxlength="4000" value="#FORM.SuperBigTextFromUser#">)

This will still cause an error if more than 4K chars are entered, but you'd know that it's because there really are more than 4000 chars and not a DB driver issue.

Anything close to that, or anything greater than that?

Also, what command is CF trying to execute when the error occurs?