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.
Solution
Problem solved. Using font 'Microsoft YaHei'
- Oracle Apex: ORA-24344 Success with compilation error
- Oracle database 23ai: Error ORA-02264 occurs, but I can neither find a constraint with the specified name nor drop one
- Select only one role for user when logging to Oracle
- How can I connect to an Oracle database as SYS using an ADO connection string?
- Oracle Apex passing item results from a Select list to another Select list on the same page
- Oracle database seems to be locked
- SQL developer not show results if they match certain criteria
- Only include records that all rows within a group meet a specific condtion
- ORA-28001: The password has expired
- Oracle/SQL PLUS: How to spool a log and write intermittently throughout script
- How to kill all active and inactive oracle sessions for user
- Is Execute SQL script a preferable way to run PL/SQL?
- What is the disadvantage of using SHRINK SPACE for an Oracle Table?
- Oracle JSON Query with hyphen-key
- Could not find file 'C:\SomePath\Oracle.DataAccess.Common.Configuration.Section.xsd' when connecting to Oracle server
- Aging distribution by location using receipt transactions
- How to shrink secure file LOBs in Oracle
- How to convert date to timestamp(DD-MON-YYYY HH24:MI:SS.FF format) in oracle?
- Save output of loop in single table in oracl SQL
- How can I confirm a database is Oracle & what version it is using SQL?
- Outer function returning multi-line values with the help of refcursors
- Spring's Stored Procedure - results coming back from procedure always empty
- How to replace unicode displaying in XML from SQL results
- How to use recursive function for product transition?
- Using condition inside subquery
- DELETE Multiple Duplicate Rows Without Column ID
- Reset sequence value with a simple SQL statement in Oracle 19c
- Aspire AddOracleDatabaseDbContext set optionsBuilder.UseQueryTrackingBehavior
- How can multiple rows be concatenated into one in Oracle without creating a stored procedure?
- SQL aggregate whether table contains a category or type of record