'Exporting an Oracle table show unrecognize symbols for local(Bangla) language data in insert statement
I am exporting a table that contains some Bangla information. If I run select statement data is showing fine but if export it as select UTF-8 or UTF8 encoding this is showing some unrecognize symbol. if I choose some different encoding it shows "???" instead of Bangla letter.
what I am missing. Please help.
Oracle DB : Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Sql developer : Java(TM) Platform 1.8.0_291 Oracle IDE 21.2.1.204.1703 Versioning Support 21.2.1.204.1703
Addes some screenshot below.
Select query showing bangla data fine. But...

After exporting using sql developer using UTF8 or UTF-8 its showing unrecognise characters.
Solution 1:[1]
Thankfully those data are exported successfully! previously I right-clicked on the table and select export option then a window came up. where I had to choose encoding option.which was giving the issues with data.

But this time I selected compressed check box option from the window. It creates a zip file and inside that found the script. and wow! my data is showing fine!

Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | user3650170 |


