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.
Solution
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.
- Difference b/w remove attribute in cfmailparam and cffile action="delete"
- ColdFusion 9, JSON, and jQuery EasyUI
- Registration process isn't working in SCORM on the production environment
- How to strip out a url variable
- How to resolve deadlock issue in ColdFusion 9: coldfusion.util.AbstractCache$Lock
- FW/1 Controller changes not updating in view
- Limiting number of pages on a paging list
- How do I get the generated key for an MSSQL "insert" query in Coldfusion 2021 script?
- Coldfusion page display issue with First Nations/Indigenous characters/fonts (unicode?)
- Insert a Coldfusion struct into a database
- Coldfusion not redirecting after login
- How do I communicate over telnet using cfml?
- Calling .Net function asking for System.Type parameter in ColdFusion
- Converting C# to ColdFusion
- How to test for null/empty string in Coldfusion query of query?
- Integrating SendGrid’s SMTP API with CFMAIL
- Convert ColdFusion Encryption using AES/Hex to C#
- Upload pdf file to GCS with REST API - Coldfusion
- Deserialize PHP array in coldfusion
- com.sun.mail.handlers.text_plain cannot be cast to javax.activation.DataContentHandler
- CFdocument losing CSS for border-bottom
- ColdFusion - What's an efficient way to search an array of structs?
- Can ColdFusion 2023 settings interfere with JavaScript?
- Creating JWT in Coldfusion for google Service account
- Did ColdFusion 2018 hotfixes 12 or 13 break query of queries?
- How do you access the result structure returned with cfoauth?
- ColdFusion cfmail special characters in subject line
- Please help: How can I scrape this web page?
- What's the correct way to allow different ColdFusion CFC's to instance each other?
- jQuery Loop Through Data in Select Statement and Have Saved Option PreSelected