Error, "The data types text and nvarchar are incompatible in the equal to operator"

Question

User1065735002 posted

Hi, i have a table in sqlexpress named Contacts:

ID   (int)   -primary key-

name   (varchar(30))

lastname   (varchar(30))

phone   (varchar(15))

fax   (varchar(15))

desc   (text)

In my default.aspx page, i have a GridView that has the conecction to this table. The GridView has the Editing and Deleting checkbox enabled but my problem is that i can't edit or delete any row when the page is running and the massage is this: "The data types text and nvarchar are incompatible in the equal to operator"

It would have to work, but i don't know what happen, Please, any help!

Answer 1

User-1786411686 posted
Handling TEXT datatypes is slightly different than regular columns. You cannot do a regular UPDATE/INSERT with TEXT column. Read up BOL for more info.

Answer 2

User-1225738063 posted
Change desc from text to varchar(max) and your issue should go away.

Answer 3

User1065735002 posted

Ok, but what is BOL?

Answer 4

User-1225738063 posted
Books On Line (The documentation/help)

Answer 5

User1065735002 posted
Thank you Motley, now i can update and delete whit that change in the data type.

Answer 6

User39490543 posted

Ok, but what is BOL?

Books Online is a great free SQL Server reference from Microsoft. You can download it and install it locally or you can access it online:
    Downloadable verson of Books Online
    Online version of Books Online

Answer 7

User-319838109 posted

ok, i have the same problem!!!!!

i changed text to vchar(max).

i dont get an error any more. but the update doesnt work either!!

i am using TINYMCE to add functionality to the textbox. when i press update it does back to view mode but ignores my alterations.

 

if i dont use the TINYMCE editor on the text box everything works fine.

Answer 8

User1707861034 posted

Thanks... ! :)