Skip to Content
0

The data types text and varchar are incompatible in the equal to operator.

Dec 26, 2016 at 09:42 AM

113

avatar image

I set "Key and Updateable Columns” in update property for a dw as i want to prevent changes written by on use to overwritten by other user already access the same row

table have many fields some of these of type text and nvarchar

now when i try to update this dw- error occurs

"The data types text and varchar are incompatible in the equal to operator."

i have read that this error can be solved by changing all text fields to be nvarchar(max) is this true( i did not try it yet as i must re select all columns in all dws)?

is there any other way to overcome this error

Best Regards

Ahmed

10 |10000 characters needed characters left characters exceeded

Start with the basics. What dbms are you using (version, edition, etc.)? What is the DDL for the table involved? The short answer is probably "yes" - change your datatypes.

0
* Please Login or Register to Answer, Follow or Comment.

0 Answers