"Implicit conversion from data type ntext to varchar is not allowed"
843859Mar 13 2007 — edited Mar 19 2007Hi,
I am calling a stored procedure in SQL Server 2000 that inserts data in to a table. One of the parameters that it takes is a varchar. From the java code I pass a XML as a string for that parameter. It works fine in most of the cases except when the XML string is a huge one say the length is about 5400, I get the following error.
[BEA][SQLServer JDBC Driver][SQLServer]Implicit conversion from data type ntext to varchar is not allowed. Use the CONVERT function to run this query
can anyone help?
thanks