A warning on Transformation job on the import of a special character.
APT_CombinedOperatorController(0),0: Invalid character(s) ([xE9]) found converting string (code point(s): 0000-Donn[xE9]es Groupe bMx S.A.) from codepage UTF-8 to Unicode, substituting.
I have tried to put CHAR, NCHAR, VARCHAR, NVARCHAR. And still have a problem.
Solution -
Change the input field to VARCHAR and changed the T Table from UTF-8 to MS-1250.
APT_CombinedOperatorController(0),0: Invalid character(s) ([xE9]) found converting string (code point(s): 0000-Donn[xE9]es Groupe bMx S.A.) from codepage UTF-8 to Unicode, substituting.
I have tried to put CHAR, NCHAR, VARCHAR, NVARCHAR. And still have a problem.
Solution -
Change the input field to VARCHAR and changed the T Table from UTF-8 to MS-1250.