[Microsoft] [odbc SQL Server Driver] [SQL Server] parameter data type text is invalid for parameter 1 of the replace function.

When it comes to text replacement in databases, most people first think of the replace function:

Update table set column = Replace (column, 'oldkeyword', 'newkeyword ')

However, when column is text or ntext, the preceding query will return the error "Text of the parameter data type is invalid for parameter 1 of the replace function ". It turns out that string operations cannot be performed on data of the text or ntext type in queries. At this time, the most commonly used method is to treat text as varchar (when the actual content length is less than 8000 bytes) or treat ntext as nvarchar (when the actual content length is less than 4000 bytes:

Update table set column = Replace (cast (column as varchar (8000), 'oldkeyword', 'newkeyword ')

Update table set column = Replace (cast (column as nvarchar (4000), 'oldkeyword', 'newkeyword ')