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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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
810 views