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.

CodePudding user response：

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!

Now it's working!