ANNOUNCEMENT: community.oracle.com is currently Read only due to planned upgrade until 29-Sep-2020 9:30 AM Pacific Time. Any changes made during Read only mode will be lost and will need to be re-entered when the application is back read/write.
Is there a way to make SQL Developer to support both English and French character sets at the same time?
Our database contains data with both English and French in Varchar2 and CLOB columns.When I query the data or try to run an insert script, SQL developer either crashes or puts funny character sets such as diamonds offset in black with character sets. The insert scripts are supplied to me with the French character set if the accents and replace them with the character only it would be better that the tool crashing.
When I look at the NLS settings you can change a default language but you cannot work in multiple versions.