UTF-8 error in odbc stage accessing oracle 10G database

Moderators: chulett, rschirm

Post Reply
MukundShastri
Premium Member
Premium Member
Posts: 103
Joined: Tue Oct 14, 2003 4:07 am

UTF-8 error in odbc stage accessing oracle 10G database

Post by MukundShastri »

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
Post Reply