When Exporting Data of a Table using Export Data -> Insert, Data Comes out with Incorrect Characters
(Doc ID 413617.1)
Last updated on FEBRUARY 03, 2019
Applies to:Oracle SQL Developer - Version: 188.8.131.52.64 to 184.108.40.206.14
This problem can occur on any platform.
In SQL Developer when trying export/import data from a table garbage data results.
Locale is set to Portuguese and Characterset used by Database is WE8MSWIN1252.
Steps To Reproduce:
1. Set O/S locale to Portuguese.
2. Launch SQL Developer.
3. Export data of a table.
5. When importing it back, table data contains garbage characters.
- Text in database : "Detalhe Declaração Periódica de IVA (3)"
- Text in the exported file : "Detalhe DeclaraÃ§Ã£o PeriÃ³dica de IVA (3)"
Testing the same from outside SQL Developer is working fine.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document