We have released PL/SQL Developer 7.0.3 which supports Unicode data in the result set of the SQL Window, Report Window and Test Window. This will allow you to query, modify and export character data in Unicode format:
Note that the SQL and PL/SQL Editors are not yet Unicode compatible, so you will not be able to work with Unicode in the the editors of the Program Window, SQL Window, Report Window or Command Window.
You can download PL/SQL Developer 7.0.3 here:
http://www.allroundautomations.com/registered/plsqldev.html
A list with additional enhancements and fixes is also available from this page.
How to enable Unicode?
To enable Unicode you need to have a database that is created with an UTF-8 or UTF-16 database character set or national character set (for NVARCHAR2, NCHAR, NCLOB and so on). The SQL Window, Report Window and Test Window will automatically detect the Unicode data, and will display the data as such. The Large Data Editor of the SQL Window will also automatically display Unicode data correctly. The client-side character set of the NLS_LANG key (Language_Territory.Charset) does not need to be a Unicode character set.
Restrictions
As noted above, the editors do not yet support Unicode data for the SQL or PL/SQL sources (this feature will be added in the next release). As a consequence you should preferably not set the client-side character set of the NLS_LANG key (Language_Territory.Charset) to a Unicode character set. If you do set it to a Unicode character set, the source will be edited with the national character set of the Windows client, which will then be compiled as Unicode. For non-ascii characters this will lead to incorrect results.