I’m trying to save a BLOB file, which has Japanese text, in xls format. The BLOB contains tab delimited data and one of the data fields has japanese characters. I’m using Toad 10.5.0.41 and I’m able to see the japanese characters in the Data Grid just fine, but when I save the BLOB as excel (by double clicking the BLOB field) from BLOB edit popup, the saved excel doesn’t show the japanese characters correctly.
I’m on Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit
NLS_TERRITORY : AMERICA
NLS_CHARACTERSET : UTF8
I even modified the NLS_LANG on the client machine (Windows OS) to AMERICAN_AMERICA.JA16SJIS but it didn’t solve the problem.
Can you please help me and tell me what I’m doing wrong
Appreciate your help