Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SQLDeveloper Editor Encoding

User_R99FLApr 24 2022

Screenshot from 2022-04-24 17-17-30.pngSQLDeveloper has an option to change the Encoding of database files (e.g. .sql files). This can be done from Tools -> Preferences -> Environment -> Encoding. If I set this to ASCII and restart the application, when I open existing .sql files with Unicode content, the Unicode characters do not display. This is understandable. Yet when I create a new database .sql file from SQLDeveloper, I am able to paste Unicode characters (e.g. emojis) into the editor, and then insert them into my tables. How does the editor recognize that pasted content is Unicode? Does the encoding from Preferences/Environment not extend to pasted information into the editor? If not, what does? Is there a relation of this ability of the editor to detect Unicode with the editor's fonts?

This post has been answered by thatJeffSmith-Oracle on Apr 26 2022
Jump to Answer
Comments
Post Details
Added on Apr 24 2022
6 comments
15,594 views