UTF-8 error in odbc stage accessing oracle 10G database
Posted: Fri Aug 31, 2007 11:00 am
We are using DataStage Parallel jobs to load records in Oracle DB but the jobs uses ODBC Enterprise to connect to Oracle 10G DB. While running the jobs we are getting below warnings for some of the columns in DataBase table.
main_program: Invalid character(s) ([x98]) found converting string (code point(s): TRANS_CREATOR[x00][x00][x00][x18][x01][x00][x00][x18][x00][x00][x00][x98][x90]) from codepage UTF-8 to Unicode, substituting.
main_program: Invalid character(s) ([xA0]) found converting string (code point(s): PROCESSING_STATUS[x00][x00][x00][x00][x00][x00][x00][x00][x00][x00][x00][x00][x00][x00][x00][xA0][x18]) from codepage UTF-8 to Unicode, substituting.
Similar error for other columns also; Do we need to upgrade the odbc driver if database is upgraded to 10G ?
Thanks
Mukund
main_program: Invalid character(s) ([x98]) found converting string (code point(s): TRANS_CREATOR[x00][x00][x00][x18][x01][x00][x00][x18][x00][x00][x00][x98][x90]) from codepage UTF-8 to Unicode, substituting.
main_program: Invalid character(s) ([xA0]) found converting string (code point(s): PROCESSING_STATUS[x00][x00][x00][x00][x00][x00][x00][x00][x00][x00][x00][x00][x00][x00][x00][xA0][x18]) from codepage UTF-8 to Unicode, substituting.
Similar error for other columns also; Do we need to upgrade the odbc driver if database is upgraded to 10G ?
Thanks
Mukund