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

oracle encoding utf-8 oracle-sqldeveloper non-english
actan picture actan · Jun 28, 2016 · Viewed 29.2k times · Source

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

Answer

actan picture actan · Jun 30, 2016

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

Related questions

Get list of all tables in Oracle?

How do I query an Oracle database to display the names of all tables in it?

Read More
How do I limit the number of rows returned by an Oracle query after ordering?

Is there a way to make an Oracle query behave like it contains a MySQL limit clause? In MySQL, I can do this: select * from sometable order by name limit 20,10 to get the 21st to the 30th rows (skip the …

Read More
ORA-12514 TNS:listener does not currently know of service requested in connect descriptor

We have an application running locally where we're experiencing the following error: ORA-12514: TNS:listener does not currently know of service requested in connect descriptor I've tested the connection using TNSPing which resolved correctly and I tried SQLPlus to try …

Read More