Home » Other » Client Tools » Does Oracle SQL Developer Support Unicode ? (Oracle SQL Developer, v4.0.3, Windows 7 Professional)
Does Oracle SQL Developer Support Unicode ? [message #646748] Thu, 07 January 2016 19:26 Go to next message
kittokevin
Messages: 3
Registered: December 2015
Junior Member
Hello Oracle Experts,

We recently started to load Unicode data to Our Oracle database through an ETL application. Here are the locale parameters of the database.


NLS_LANGUAGE AMERICAN
NLS_TERRITORY AMERICA
NLS_CURRENCY $
NLS_ISO_CURRENCY AMERICA
NLS_NUMERIC_CHARACTERS .,
NLS_CALENDAR GREGORIAN
NLS_DATE_FORMAT MM/DD/YYYY HH24:MI:SS
NLS_DATE_LANGUAGE AMERICAN
NLS_CHARACTERSET WE8ISO8859P1
NLS_SORT BINARY
NLS_TIME_FORMAT HH.MI.SSXFF AM
NLS_TIMESTAMP_FORMAT MM/DD/YYYY HH.MI.SSXFF AM


We have set up our sqlplus on AIX properly, and thus we can select unicode values without any problems.


SQL> SELECT FIELD_DATA FROM ETL.UTF8_TEST;

FIELD_DATA
-------------
∑α ≥ β


However on Windows, we tried the same query on Oracle SQL developer, and here's what we got:

SELECT FIELD_DATA FROM ETL.UTF8_TEST;

FIELD_DATA
-------------
∑α ≥ β


We changed the setting: Tools -> Preferences -> Environment -> Encoding to UTF8, but it didn't help.

Do you have any thoughts ?

[Updated on: Thu, 07 January 2016 19:28]

Report message to a moderator

Re: Does Oracle SQL Developer Support Unicode ? [message #646758 is a reply to message #646748] Fri, 08 January 2016 05:08 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
Your database character set is not Unicode, it is WE8ISO8859P1. So far, by luck, your Unicode data has been mapped onto that characterset successfully. When you run SQL*Plus on the server, it will be picking up the same characterset, so everything (so far) display correctly. But when you set your client character to UTF8, SQL*Net is being forced to do the conversion from WE8ISO8859P1 to UTF8, which is where it all goes wrong.
Does SQL Developer show the data correctly if you set it to use WE8ISO8859P1 ?

Re: Does Oracle SQL Developer Support Unicode ? [message #646760 is a reply to message #646748] Fri, 08 January 2016 06:53 Go to previous messageGo to next message
thatjeffsmith
Messages: 81
Registered: July 2009
Location: Raleigh, NC
Member

SQL Developer is a java application, it natively supports UNICODE.

Display issues (in SQL Developer) generally are caused by using a code editor font that doesn't support your character(s).
Re: Does Oracle SQL Developer Support Unicode ? [message #646786 is a reply to message #646758] Fri, 08 January 2016 13:10 Go to previous messageGo to next message
kittokevin
Messages: 3
Registered: December 2015
Junior Member
Hi John,

Thanks for your reply. We changed setting: Tools -> Preferences -> Environment -> Encoding to ISO-8859-1, but is still didn't help.
SELECT FIELD_DATA FROM UTF8_TEST;

FIELD_DATA
-------------
∑α ≥ β

In fact, I don't actually know how "Encoding" is used in Oracle SQL Developer. Is it related to the worksheet editor and query result? Does it have something to do with the NLS_LANG?

When using SQL*PLUS in AIX, the settings are much simpler. We only need to set NLS_LANG=American_America.WE8ISO8859P1 and make Character set Translation to UTF-8 in PuTTY. And Unicode display works immediately.

However on Windows, using Oracle SQL Developer, we couldn't figure out a way to properly change its configuration for Unicode. And there's not much information online about it. In terms of NLS_LANG, we used American_America.WE8ISO8859P1, American_America.WE8MSWIN1252, and American_America.UTF8, but none of those gave us a slight clue of improvements. Kinda frustrated about this tool now.
Re: Does Oracle SQL Developer Support Unicode ? [message #646787 is a reply to message #646786] Fri, 08 January 2016 13:22 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
https://community.oracle.com/community/database/developer-tools/sql_developer

AFAIK - Actual Oracle SQL Developer staff monitor forum above & you might get faster & better answers there.
Re: Does Oracle SQL Developer Support Unicode ? [message #646788 is a reply to message #646786] Fri, 08 January 2016 13:35 Go to previous message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
You aren't using unicode in your database. This could be your problem.
Previous Topic: To call SQL script based on date range
Next Topic: To Run Sql script in background
Goto Forum:
  


Current Time: Thu Mar 28 18:42:47 CDT 2024