Search code examples
oracleexportlocal

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.

enter image description here

Select query showing bangla data fine. But... enter image description here

After exporting using sql developer using UTF8 or UTF-8 its showing unrecognise characters.

Solution

  • 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. enter image description here

    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! enter image description here

    Now it's working! enter image description here