Support Topics Documentation Slack YouTube Blog

Handle Object with Text Longer than 21k

How does one handle saving an object where a column, say “text”, is longer than 21k characters? The limit throws an error.

Databases are not that great for large amount of text. What I’d recommend in that case is to store your text in a file. That operation will return the URL for the file. Then you can store that URL in a column in your data table.

Is it possible to write a service or beforeCreate handler that can detect when the amount of text is too large and move it to a file?

Yes, it’s possible, check this docs https://backendless.com/docs/bl-js/bl_event_handlers.html

Regards,
Stanislaw