This content has been marked as final. Show 8 replies
If you run the following query in SQL*Plus
select * from NLS_DATABASE_PARAMETERS WHERE parameter like 'NLS%'You will see the values for parameters like NLS_LANGUAGE, etc.
Try checking and resetting as needed your SQL Developer NLS settings in:
Tools -> Preferences -> Database -> NLSRegards,
SQL Developer Team
Thanks for your response. The Customer says that this was done at their end.
He created a temp table and inserted the chinese character with SQL Developer but no problem was found and displayed it well as intended.
This would indicate an issue with the characterset conversion process, since storing and displaying Chinese characters using SQL Developer now works as advertised. The link provided is not an official Oracle link - can you confirm that they followed the official conversion process ? Did they do this conversion themselves or involve Oracle or some other consulting company ?