| Does Oracle SQL Developer Support Unicode ? [message #646748] |
Thu, 07 January 2016 19:26  |
 |
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  |
John Watson
Messages: 8962
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 #646786 is a reply to message #646758] |
Fri, 08 January 2016 13:10 |
|
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.
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
