govind.sharma (4/18/2008)
Problem is still remainingit think it should not worked because The Then Column Datatype is Char not NChar
That is the second part of the problem (sorry I missed that :)). You have two choices, either change the table or column collation for the target table to Japanese_CI_AS or change to nchar/nvarchar data type.
Regards,
Andras