Is it possible to have a data extension field in SFMC which holds more then 4000 characters?
I want to build a dynamic email on the fly with HTML-code passed over via the soap api, but I’m having trouble as text fields can only hold a maximum of 4000 characters. (At the moment I split the HTML in several containers to get this to work.)
Thank you for visiting the Q&A section on Magenaut. Please note that all the answers may not help you solve the issue immediately. So please treat them as advisements. If you found the post helpful (or not), leave a comment & I’ll get back to you as soon as possible.
The limitation is just a limitation for the input of the length field, but you can circumvent this by leaving the length-field empty. If you do so Marketing Cloud uses
VARCHAR(MAX) for the field in the database. (EDIT: This solution only works when creating a data extension in Email Studio. Unfortunately Contact Builder doesn’t allow this workaround.)
Important: Please note, that this is a workaround and should used with extreme caution and only if really necessary, as there is no way of knowing if this workaround will function in the future. So if possible in, try to use smaller columns.