I get this error, while trying to insert over 4000 characters long string into varchar(8000) column.
The error it shows is:
Disallowed implicit conversion from data type ntext to data type varchar, table 'table1', column 'column1'. Use the CONVERT function to run this query.
I googled and found that MSSQL converts over 4000character long strings automatically into ntext. Does anyone know, how can I resolve this problem? I could use procedures, but that is not a solution right now.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hi!
I get this error, while trying to insert over 4000 characters long string into varchar(8000) column.
The error it shows is:
Disallowed implicit conversion from data type ntext to data type varchar, table 'table1', column 'column1'. Use the CONVERT function to run this query.
I googled and found that MSSQL converts over 4000character long strings automatically into ntext. Does anyone know, how can I resolve this problem? I could use procedures, but that is not a solution right now.