I have a strange issue: i created a simple stored procedure in Microsoft SQL Server:
@id INT,
@ntextParameter NTEXT,
...
UPDATE xxx SET [Field] = @ntextParameter WHERE ID = @id
but when i execute it with a long text, it update the table and simply cut the text without any visible error
As suggested by Jeroen Mostert and Damien_The_Unbeliever in the comments the NTEXT type field is deprecated, I found out that NVARCHAR(MAX) is longer that 4000 character (maximum storage size is 2^30-1 characters (2 GB)) and that I need