Menu
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.
908
All you need to do is to Set the Font as "Arial Unicode MS" and make the character encoding as "UTF16" to show Kanji in your results Window. user6774418 wrote: All you need to do is to Set the Font as "Arial Unicode MS" and make the character encoding as "UTF16" to show Kanji in your results Window.
SQLDeveloper has an option to change the Encoding of database files (e.g. . sql files). This can be done from Tools -> Preferences -> Environment -> Encoding.
You can replace special characters using the Oracle REPLACE function. To replace both carriage return and new line characters, you must use nested REPLACE functions. If you want to replace a lot of special characters, using many nested REPLACE functions can get messy and could have performance impacts.
From Oracle SQL Developer's menu go to: Tools > Preferences. From the Preferences dialog, select Database > NLS from the left panel. From the list of NLS parameters, enter DD-MON-RR HH24:MI:SS into the Date Format field. Save and close the dialog, done!
Problem solved. Using font 'Microsoft YaHei'
184
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
