4 Replies Latest reply on Aug 13, 2014 8:59 AM by 2719642

How to display Chinese

2719642 Aug 8, 2014 2:56 AM

Dear all,

I have problem on chinese display in SQL Developer. I used 64 bit SQL Developer with JDK Included.

After searching through the Internet, most suggestions are related to the following registry.

HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOMEID\NLS_LANG

However, my windows does not have such registry setting. Actually, there is no need to install JDK and SQL Developer, so the registry is not created.

I also modify the following setting to UTF-8 and it is useless.

Please give me other suggestion.

Thanks.

Michael.

1. Re: How to display Chinese

thatJeffSmith-Oracle Aug 8, 2014 11:48 AM (in response to 2719642)

Do you want a Chinese interface or do you need help getting chinese characters showing in an editor or grid?
Like Show 0 Likes(0)

Actions
2. Re: How to display Chinese

2719642 Aug 11, 2014 2:20 AM (in response to thatJeffSmith-Oracle)

Dear Jeff,

I would like to know how to display query result in Chinese and use SPOOL to output the query result in CSV format.

I am using Win 7 64 bits (English version) and SQL Developer 64 bits 4.0.2 version included JDK. (I have tested 32 bit 3.0 SQL developer and still can't display Chinese well).

Would you please give me suggestion?

Thanks.
Like Show 0 Likes(0)

Actions
3. Re: How to display Chinese

thatJeffSmith-Oracle Aug 11, 2014 2:37 AM (in response to 2719642)

Yes, make sure your editor display font is configured to something that supports the Chinese characters you're trying to work with.
1 person found this helpful
Like Show 0 Likes(0)

Actions
4. Re: How to display Chinese

2719642 Aug 13, 2014 8:59 AM (in response to thatJeffSmith-Oracle)

Dear Jeff,

Thank you for your help. Finally, the problem is database character set problem. The database is converted again (by vendor) and everything is fine now.

Thanks.
Like Show 0 Likes(0)

Actions