cf_sql_longvarchar cut off saving a variable from coldfusion to sql 2008

Question

Is there a character limit on cf_sql_longvarchar that I can increase, or perhaps an alternative? It seems to be cut off at 43,679 characters or somewhere around 40-45 kb.

Answer 1

Usually a combination of CLOB and an Long Text Buffer solve the problem.

I use the example below only for queries that I know have to move lots of data. I don't use it universally because then JVM memory issues can come up.