When Exporting Data of a Table using Export Data -> Insert, Data Comes out with Incorrect Characters

(Doc ID 413617.1)

Last updated on MARCH 16, 2009

Applies to:

Oracle SQL Developer - Version: to
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