Inserting data into Oracle DB using UTF 8
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎01-08-2020 09:44 AM
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 2
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎01-09-2020 12:11 AM
what is your data source, Flat files?
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎01-09-2020 01:19 AM
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.
