Hello DBA GURUS,

I am performing a conversion from ASCII TO EBCDIC.
-------------------------------------------------------
Eg:-
ebc_str:=convert(ascii_string,'WE8EBCDIC500','US7ASCII');
-------------------------------------------------------

This is working fine in one oracle database where the NLS_CHARACTERSET
is US7ASCII but not working in another one where the NLS_CHARACTERSET is
UTF8. I am getting different EBCDIC results. Because of this, I am not
able to proceed further with my processing.

My character Sets are different. So what changes I should do, in my code
so that I will get the expected result.

I am expecting a solution, where I need not have to change the
NLS_CHARACTERSET.

Please help!!!! It's urgent





Regards,
Raj.




Oracle LazyDBA home page