• What we discovered for a solution: We change the default encoding of UTF-8 to UTF-16 and then in the insert code change the varchar to nvarchar. That worked and I didn't need to change collation.

    Thanks

    Kathy