Hi

I store a returned WebService call in a standard DB2 varchar column.
However a SUB character appeared.

Looking at the original UTF8, the character was a "U+2019 : RIGHT SINGLE QUOTATION MARK {single comma quotation mark}" according to https://www.babelstone.co.uk/Unicode/whatisit.html

the character is ’

In the expression evaluator it shows that Utf8toOEM, replaces the ’ with a standard '
While the Utf8toAnsi, shows a diamond-with-question-mark in the debugger.

As the DB2 table is ANSI, it would explain the SUB, however, that does not seem correct...

Click image for larger version. 

Name:	2021-07-19_18-26-42.png 
Views:	123 
Size:	1.4 KB 
ID:	14744

How can I ensure that this common character is properly translated to ANSI and thus properly saved in the tables.
ps. changing the tables to UTF8 is not possible yet, as still too many pre-20.0 applications.

Kind regards
Marco