How to Create Text Fields Exceeding 4000 Characters in Marketing Cloud Data Extensions

1. Configuration Procedure

Follow these steps to create a text field that exceeds 4000 characters (equivalent to NVARCHAR(MAX)).

1. Open the Data Extension creation (or editing) screen in Email Studio.

2. Create a new field and select Text from the Data Type dropdown.

3. In the Length field, leave it blank or enter -1. Do not enter a specific number.

4. Save the Data Extension.

• Result: The system will define this column as NVARCHAR(MAX) in the backend database, allowing it to store up to approximately 2GB of data.

2. Considerations and Best Practices

You should not default to using the maximum length for all text fields just because it is available. Indiscriminate use can negatively impact system performance and design constraints. Apply this setting only to columns that strictly require more than 4000 characters.

• Query Performance: Data retrieval and SQL query processing tend to be slower for columns defined with MAX length compared to standard columns (4000 characters or less).

• Primary Key Constraints: You cannot use a MAX length column (blank length) as a Primary Key. Primary Keys have strict index size limits, so columns used as keys must have a defined, minimal length.

• Storage Management: If extremely long strings are inserted repeatedly, the storage size of your Data Extension can increase unexpectedly.