Forum Discussion

suresh_kumar_ro's avatar
suresh_kumar_ro
New Contributor
6 years ago

Inserting data into Oracle DB using UTF 8

How can we Insert data into Oracle table in UTF 8 character set . There is no option to write data in UTF8. Without UTF8, word MÉXICO is inserted as M�ICO .

Can someone please help.

2 Replies

  • suresh_kumar_ro's avatar
    suresh_kumar_ro
    New Contributor
    6 years ago

    Thanks for reply.

    It reads data from Oracle db and Insert into Oracle db.

    In Source table it is :- MÉXICO

    While reading data from source db it’s showing as M�ICO. and same is inserted into target table.