Skip to Content

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

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

Add comment
10|10000 characters needed characters exceeded

  • Former Member

    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.

  • Get RSS Feed

0 Answers