My Oracle Support Banner

Exporting Table With Special Characters Using / * CSV * / & F5 Results in Strange Characters (Doc ID 2620058.1)

Last updated on DECEMBER 14, 2020

Applies to:

Oracle SQL Developer - Version 18.3 to 20.2
Information in this document applies to any platform.

Symptoms

Environment
-------------------
SQL Developer 18.3
Linux x86 RH6
Database 12.1.0.2.0

Problem
-------------
When you want to export a table with special characters with / * csv * / and press F5, the result is shown with strange characters. The same goes for /* xml and html */.

Output via 4.1.x
--------------------
Málaga, España

Output via 18.3
-------------------
"LOC"
"Málaga, España"

Works
----------------
SQL Developer 4.1.1.19 and manual import also works.

Code
------------

Changes

 Upgraded to newer version.

Cause

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
Symptoms
Changes
Cause
Solution
References


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