My Oracle Support Banner

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: 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.


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.