Skip to Main Content
Forums

Database Software

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!

Arabic characters issue in SQL Developer

jr-phDBAJan 9 2017 — edited Jan 12 2017

Hi ALL,

This thread was created in relation to troubleshoot further the issue in my previous thread NLS_LANG.

Details:

1. Result when running a query in sql developer some char became a box(in other machine it's a ?)

pastedImage_0.png

2. Using Toad for Oracle, everything were fine.

pastedImage_3.png

Note: SQL Developer and Toad for Oracle were in the same machine.

Action taken:

1. Change encoding in sql developer to UTF8, UTF-8, ISO-8859-6, ISO8859-6, ISO_8859-6, 8859_6

Tools>Preferences>Environment>Encoding

pastedImage_5.png

  1. Change to different font

Tools>Preferences>Code Editor>Fonts

pastedImage_6.png

Additonal info:

We're using 11.2.0.4 having NLS_CHARACTERSET AR8ISO8859P6. Database client was installed and configured having the same NLS_CHARACTERSET(NLS_LANG). We're trying to use sql developer to load data to cloud but after uploading, data didn't appear as expected.

Thank you in advance..
This post has been answered by Sergiusz Wolicki-Oracle on Jan 10 2017
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 9 2017
Added on Jan 9 2017
#database-key-features, #globalization-support
7 comments
23,664 views