When Exporting Data of a Table using Export Data -> Insert, Data Comes out with Incorrect Characters
Last updated on MARCH 16, 2009
Applies to:Oracle SQL Developer - Version: 22.214.171.124.64 to 126.96.36.199.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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms