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.

How to display utf8 characters in sql developer

692593Mar 24 2009 — edited Mar 26 2009
Is there a setting I need to change in sql developer in order to display utf8 characters?
I am seeing weird characters when displaying chinise/arabic characters in sql developer. I can display the same data just fine in Putty ( I changed the following setting in putty before I was able to display utf8 characters ok: Windows->Translation and selected UTF8) .


Thanks,
SK

Comments

Jim Smith
You could try changing the encoding in Tools | Preferences |Environment
692593
Thanks Jim,
I changed encoding in Tools | Preferences |Environment to utf8/utf-8, but sql developer is still not displaying the correct charactes
Srini Chavali-Oracle
Pl post the following -

1. OS version and oracle version
2. NLS settings for the database
3. Output from sqlplus showing the UTF8 characters
4. Same output from SQLDeveloper

HTH
Srini
692593
*1. OS version and oracle version*
Windows XP Professional/Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production

*2. NLS settings for the database*
AL32UTF8

*3. Output from sqlplus showing the UTF8 characters*
\什么是统码
ANSI
\什么是统码
يونی‌کُد چيست؟.utf8

*4. Same output from SQLDeveloper*
\什么是统码 ANSI
\什么是统码 يونی‌کُد چيست؟.utf8

Thanks,
Salem
Srini Chavali-Oracle
Ouch ;-)

>
\什么是统码
>

Can you confirm that this this valid data ?

Srini
692593
:) I know sorry sqlplus (which I dont' use) doesn't display the data right too. But, data is valid and it displays ok in putty...
1 - 6
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Apr 23 2009
Added on Mar 24 2009
6 comments
6,646 views