Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

how to use sql developer to export UTF8 data?

jeffhanFeb 3 2012 — edited Feb 7 2012

i am getting confused with this.
My database is using UTF8 as NLS_CHARACTERSET.

Using sql developer i can browsing the unicode data without any problem ( i can see all those special characters). However, when i was trying to export the data by using "export" by right click on schema, it exports the inserts sql out of sql worksheet with all "??" for special characters.
i was playing with encode for export settings. Also tried set NLS_LANG variable on my client side. No luck!

now i am totally lost and can't understand why the data can be displayed correctly but not exported correctly.

Thanks for any comments or suggestions.

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 6 2012

Added on Feb 3 2012

#general-database-discussions

4 comments

11,321 views