Apparently I was using the correct data type and everything was correct, however the SQL Server Management Studio truncates the output when querying a nvarchar(max), varchar(max), and such fields, this caused a confusion with not only myself but also the customer where they assumed the data was truncated on storage.

Use of a different database tool showed that the data was correct and complete, regardless what Microsoft's own software declared.