Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1249
  • Last Modified:

Retrieval of Foreign characters from Oracle DB

Team,

I am trying to retrieve the foreign characters (especially Japanese) from Oracle Database using SQL*Plus or the 3rd party tool called PL/SQL Developer (equivalent to Toad) and bring this into a Text file;

OR using the OLE DB Provider for Oracle via SQL Server 2000.  

In both cases, I am seeing some junk characters.

Initially, it was giving inverted question marks.

Upon change the Registry Editor for Oracle to say AMERICAN_AMERICA.UTF8 (from West. English Code page 8859), it started giving only the junk characters.

What should I do to get the actual Japanese characters.  Any help or suggestions would be very much appreciated.  Again, it is NOT only Japanese, this DB contains mainly English and Japanese.  Both should come in one retrieval (Query).

Thanks,
Vp
0
jsrams
Asked:
jsrams
  • 3
  • 3
1 Solution
 
jsramsAuthor Commented:
Team,

BTW, I forgot to say this to you folks.

I also set the system env. variable to NLS_LANG = AMERICAN_AMERICA.UTF8

Even if I set this, I get only the junk characters.

Appreciate if you could have any suggestions for me please.

Thanks, Vp
0
 
actonwangCommented:
The display on your client tool may also depend on your character set setting on your OS itself. Does your OS diplay Japanese?
0
 
jsramsAuthor Commented:
First of all thank you very much for your reply.  I am waiting for such responses.  

The Win2K O/S properly shows in the Internet Explorer with the file that has the actual Japanese characters.   No issues.  This means the O/S has the plugins.  But, when I opened it up in Notepad it just says "box" character.  

Where should I check to see the O/S has the correct settings.

Also, I tried with various settings at the o/S level and nothing helped.  Either it shows the junk characters or

Any help would be much appreciated.

It shows either characters like "þþþþ 4 þþþþ 4F " when I set my OS Env. Variable to WEPC850 (OR)
inverted question marks for no variable settings or West. English or WE8MSWIN1252 (OR)
question marks for US8PC437 (Active COde page 437) or US7ASCII (OR)
junk characters like "市谷台町 4 大鷹ビル 4F" for American_America.UTF8 (OR)
some other junk like "ƒ‚ƒWƒ…[ƒ‹ƒrƒWƒlƒXƒ†ƒjƒbƒg"  when using JA16SJIS

That's my problem.  

My registry editor is set to American_America.UTF8 for NLS_LANG

Thanks in adavnce for all your help and appreciate if you could let me know, if I can do something to make your life easier to answer.

Br, Vp
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
jsramsAuthor Commented:
First of all thank you very much for your reply.  I am waiting for such responses.  

The Win2K O/S properly shows in the Internet Explorer with the file that has the actual Japanese characters.   No issues.  This means the O/S has the plugins.  But, when I opened it up in Notepad it just says "box" character.  

Where should I check to see the O/S has the correct settings.

Also, I tried with various settings at the o/S level and nothing helped.  Either it shows the junk characters or

Any help would be much appreciated.

It shows either characters like "þþþþ 4 þþþþ 4F " when I set my OS Env. Variable to WEPC850 (OR)
inverted question marks for no variable settings or West. English or WE8MSWIN1252 (OR)
question marks for US8PC437 (Active COde page 437) or US7ASCII (OR)
junk characters like "市谷台町 4 大鷹ビル 4F" for American_America.UTF8 (OR)
some other junk like "ƒ‚ƒWƒ…[ƒ‹ƒrƒWƒlƒXƒ†ƒjƒbƒg"  when using JA16SJIS

That's my problem.  

My registry editor is set to American_America.UTF8 for NLS_LANG

Thanks in adavnce for all your help and appreciate if you could let me know, if I can do something to make your life easier to answer.

For the past couple of days, I don't think we are getting the answer right.    Any help / suggestions woul be very much appreciated.  Thanks in advance.  Appreciate if you could treat this very urgent.  TIA, VP


Br, Vp
0
 
actonwangCommented:
hi,

      Explorer can set encoding for specific regardless of your OS language settings. In other words, plugins are only limited to explorer itself and doesn't neccessary mean you can see Japnese character in other programs (not at all).
      That being said, in order to see japnese characters, either:
      1. Your client tool support encoding as explorer does.
or   2. Your OS language setting supports it. For windows, you use "control panel" --> "Reginal and Lanuage Options" to see it.

Acton
0
 
actonwangCommented:
Do a simple test here actually? Change the page encoding to UTF-8 then you will see some japanese characters in your previous post before " ...for American_America.UTF8 (OR)".

IT is there , isn;t it? You just need to have a UTF8 enabled viewer to see them. Probably not PL/SQL developer if it doesn't support UT
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now