Conversion of one or more characters from XML to target collation impossible

Question

When i am transferring a varchar field which is casted from xml. transfer from one server to another it shows a error error msg shown

Msg 6355, Level 16, State 1, Line 3
Conversion of one or more characters from XML to target collation impossible

Answer 1

At last got it This is due to 'र' in the xml column. It does not support to cast to varchar so i cast the xml field to nvarchar.