Hi,
I have a situation where I am converting my JSON file to BLOB using DBMS_LOB.CONVERTTOBLOB. The JSON file contains some special characters like "€". But when the BLOB is getting generated it converts into some junk character.
The underline table from where this data is picked up displays the symbol properly. That is when I query that table I get proper "€" symbol. So in the database it is getting stored correctly. I am suspecting that it is getting changed while converting it to BLOB.
I checked the characterset on database using below query :
SELECT value$ FROM sys.props$ WHERE name = 'NLS_CHARACTERSET' ;
It returns "AL32UTF8"
Also, If I run @[$NLS_LANG]. on putty It gives :
SP2-0310: unable to open file "[American_America.AL32UTF8]..sql"
which confirms that in the NLS_LANG parameter also is properly set.
Can you please suggest , why still I am getting the junk characters in the generated BLOB file ?
Regards,
Abha