can not view japanese characters in excel when saved from BLOB

Toad for Oracle
1

Hello Gurus,

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_LANGUAGE: AMERICAN
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 :frowning:

Appreciate your help

2

BLOB fields are intended for Binary data. CLOBs are intended for text.

If this is BLOB field and not CLOB, switching to CLOB could solve the problem.

If it is a CLOB, I’m not sure what the problem could be. What is your process in Toad to get the data from your table to excel?

-John