June 22nd, 2013, 01:15 AM
Help with Japanese characters in Oracle
I have a XML file which contains Japanese characters and it is parsed by a unix script and nawk utlity and writes the data to a flat file separated by delimiter. I could the Japanese characters proper in the flat file.
I use SQLoader (within a unix script) to import this data from the flat file to Oracle database. If I view the data in the database through Toad, the Japanese characters are showing differently (not as in XML or in flat file).
But if do a export for the particular table to a flat file through Toad, I can see the Japanese characters proper in the exported flat file.
(Note : I have set the env variables NLS_LANG=Japanese_Japan.JA16SJIS, LC_CTYPE="en_CA.UTF-8" in both XML parser and the loader script)
Can you please let me know the reason why I couln't see the Japanese characters while viewing through Toad.
June 24th, 2013, 07:35 AM
I suspect it may be due to the MS Windoze code page?
Originally Posted by tsrini123