Retrieval of Foreign characters from Oracle DB
Posted on 2006-04-23
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).