Skip to Main Content
Forums

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!

SQL Developer & Unicode Chars

497371Mar 10 2006 — edited May 28 2008
Running SQL Developer on Windows XP.

Tool looks good, just one thing, we have Japanese/Korean text (not much at the moment) in our Oracle 9i/Oracle 10g (AL32UTF8)

When I run the query in the sql editor, the chars appear as small rectangles.
Exporting this as XML and loading into an XML viewer (like IE), all the chars appear fine.
When I copy the text from the data results grid and paste into the sql editor window (after tweaking the prefs), the chars appear fine.

so I am wondering ... how can I get the text in the data grid to show the Japanese text ?

Is there a setting I have missed ? or would this be an enhancement ?
We will be storing more and more international chars and having a tool capable of viewing it would be something we have not found in other tools we have trialed.

Comments

unknown-7404
You should not do this.

Environment variables such as PATH can only give preference to one item of any given name. With DLLs for example the first DLL of any given name that is found will be the one loaded by Windows. It would be up to the software doing the loading to determine if that is the correct version and most software just looks by name.

That is what is known as 'dll hell'; the wrong version of a dll is being used.

You don't need both clients installed so why do you want to do that?
Pl identify which version of Win 7 - you will need Professional or higher. Pl also identify which exact version of Oracle client.

I have no personal experience with this myself, but the 11gR2 docs say you can install both the 32-bit and 64-bit clients as long as you use different ORACLE_BASE directories.

http://docs.oracle.com/cd/E11882_01/relnotes.112/e23557/toc.htm#CJADGJDB

HTH
Srini
1 person found this helpful
Helios-GunesEROL
Hi;

By using different path yes you can install.

Please review:
Master Note For Oracle Database Client Installation [ID 1157463.1]
Client / Server / Interoperability Support Between Different Oracle Versions [ID 207303.1]


Regard
Helios
1 person found this helpful
941843
Windows 7 Enterprise

Oracle Client 11g (11.2.0.1.0)
941843
Doesn't this write both ORACLE_HOME paths to the PATH environment variable, and then cause, as mentioned above, DLL hell? With WOW64, it is unclear to me how Microsoft separates 32-bit paths from 64-bit paths.

Unfortunately, my company is running 32-bit Microsoft Office 2007 and other 32-bit programs that use the Oracle thick client install, and my company also uses 64-bit programs that require the Oracle thick client install too.

The solution thus far has been to uninstall one of the programs, and thus clean-up the %PATH% environment variable; or rearrange the order of the Oracle client homes in %PATH% to make the broken one work.
941843
After researching the links, this was still unclear if the 2 clients would conflict with each other.
1 - 6
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jun 25 2008
Added on Mar 10 2006
#sql-developer
5 comments
8,812 views