All the columns has to be of same datatype AND Length.

I faced the same issue for nvarchar columns and found that one of them was nvarchar(200) while all the others...