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: 1.1.0.23.64 to 1.1.1.25.14
This problem can occur on any platform.

Symptoms


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.

Example:

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

Cause

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