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!

special characters get lost when saving script

user11328135Apr 6 2018 — edited Apr 9 2018

Hi , when is save a sql script in Oracle SQL Developer special characters get lost.

It's possible to use special char in editor in sql and it's also possible to create a view with concatenated field, which works fine. But when i save the file special character get.

example script:

select '≥ ' ||99.88 || ' MΩm'

from dual

pastedImage_0.png

when i save script and open it again special character ≥ and Ω get lost

pastedImage_1.png

Does anybody has a solution for that. I tested it with version 18.1 on windows.

Thanks

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 7 2018
Added on Apr 6 2018
2 comments
870 views