Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have installed OracleXE and imported data into it. From SQLPLUS, I can query the data and it all shows up in English.

However, in SQLDEVELOPER, if I look at the data, it's in a nonsense format, unless I double click on it, where it turns into english? If I query the data through the SQL Worksheet, it displays in rubbish format, but again click on a data item, and it turns into English again?

Before double-clicking:

enter image description here

After double-clicking:

enter image description here

I am utterly confused.

Any ideas?

share|improve this question
Could you add a few screenshots (before/after clicking) to show us what's happening? – Nick Chammas Jul 4 '13 at 16:38
I believe it is something to do with Java, as I installed some other software, with a java interface, and the same thing seemed to be going on? – Hairy Jul 6 '13 at 6:48

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.