1 Reply Latest reply on May 6, 2015 6:19 PM by thatJeffSmith-Oracle

    Supporting of Multiple Languages

    MJ Wallace


      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.