Special character showing as question marks in table
Posted: Tue Aug 23, 2016 7:17 am
Hi,
We have a job which extracts records from Oracle table and loads to a DB2 table. No transformations.
The issue is with a NAME field where in Oracle and DB2 it is varchar (80).
one of the names has a non English character such a cross sign, a star etc (My keyboard does not have them, sorry)
So when the name comes to DB2 table these characters are just question marks (??).
After googling a bit we tried giving the unicode option in oracle stage. Now the data is coming as expected, but director has logs saying this could cause lose of data. Please advise on how we can get through this. Thank you.
We have a job which extracts records from Oracle table and loads to a DB2 table. No transformations.
The issue is with a NAME field where in Oracle and DB2 it is varchar (80).
one of the names has a non English character such a cross sign, a star etc (My keyboard does not have them, sorry)
So when the name comes to DB2 table these characters are just question marks (??).
After googling a bit we tried giving the unicode option in oracle stage. Now the data is coming as expected, but director has logs saying this could cause lose of data. Please advise on how we can get through this. Thank you.