I've found several posts regarding the same topic of an untranslatable character, but don't know how to fix the problem.
Both my target and source tables have Latin encoding on the column that I think is the problem. However, I'm still getting an error regarding this untranslatable character. I can't figure out 100% if this is related to the incoming data, but is there still a way to go around this? I've read to check the Translate_with_error (what's the exact name?) and translate_chk functions, but what do I do with them?
Have you tried something like this?
This should fix this issue.
TRANSLATE( ColumnName USING LATIN_TO_UNICODE WITH ERROR);