Stored procedure cut value of ntext parameter

311 Views Asked by At

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

1

There are 1 best solutions below

0
Matteo Zambon On

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