Hi Meena, thanks for your reply! The issue I am expreiencing is little different. I made sure that both source and target table has the column specified as VARCHAR(16) CHARACTER SET LATIN NOT CASESPECIFIC.
I am able to do what you have doen. The issue arrises when we have some special characters which in my case was some russian symbols..
I cannot reproduce the error now since we just corrected the data at source.