CODEWITHSUNDEEP
coldfusioncfqueryparam
Patrick
Patrick

Reputation: 2577

cf_sql_longvarchar cut off saving a variable from coldfusion to sql 2008

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.

Upvotes: 2

Views: 1071

Answers (1)

James A Mohler
James A Mohler

Reputation: 11120

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.

enter image description here

Upvotes: 8

Related Questions