Data truncation: Data too long for column 'Message' at row 1

Hi there!

I found when it raises an exception and my table column - varchar 1000 - cannot hold it.

How many maximum string length does Outsystems can raise for an error?

regards

Solution

Hi Gede,

You can define attribute length more than 1000, but the message means that you try to store a value longer than was is defined (so longer than 1000 characters).

However,  be carefull there is an OutSystems best practices how to isolate large text in binary data

https://success.outsystems.com/Documentation/Best_Practices/Performance_Best_Practices/Performance_Best_Practices_-_Data_model 

Regards,

Daniel

Solution

U can also use substr(txt,0,1000)