Export to Excel encoding problem
504852Feb 7 2007 — edited Nov 7 2007I am using SQL Developer 1.1 Patch 1 (1.1.1.25) on Windows 2000 with Oracle 10g (on Linux).
The database has NLS_CHARACTERSET EL8ISO8859P7
(to support Greek characters)
Although in SQL Developer the greek characters are displayed correctly in the Results and Script Output panes, when I export the results to Excel, the Greek characters are displayed as squares and other symbols:
Example:
The text: ΣΤΕΓΑΣΤΙΚΑ ΔΑΝΕΙΑ
appears in Excel as: £¤£¤
(The version of the Excel I use is Microsoft Excel 2000)
I have tried many different encodings (from Tools > Preferences > Environment > Encoding) such as cp1253, ISO-8959-7, utf-8, utf-16 but the result is always the same.
The export as CSV has no problem with the greek characters.
I also noticed that the changes to the encoding in Export Data > Export File Chooser seem to be lost (if I change it and then reselect Browse... to check it, the default from preferences is shown again).
I also have the problem mentioned in another post, that when I export data to clipboard and do paste to Excel, a value such as java.io.BufferedOutputStream@8ff9a7 is only pasted.