Search code examples
oracleencodingutf-8oracle-sqldevelopernon-english

how to make sql developer display non-English character correctly instread of displaying squares?


in sql developer--preference

Environment--encoding is already set to 'UTF-8'

Code Editor--fonts was set to 'Verdana'

Database--NLS--Language was set to 'American'

The data in db was written by Java in UTF-8 encoding (95% percent sure)

What else I need to do to make it displayed correctly?

Note: the squares characters are actually Chinese characters.

enter image description here


Solution

  • enter image description here Problem solved. Using font 'Microsoft YaHei'