Character set conversion [message #636137] |
Fri, 17 April 2015 09:29 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
xpact83
Messages: 225 Registered: October 2008 Location: philippines
|
Senior Member |
|
|
Our app server's NLS_LANG in regedit is AMERICAN_AMERICA.WE8ISO8859P1 our database character set is AMERICAN_AMERICA.WE8MSWIN1252. The problem is, the forms and report can't display chr(151) because the character set in app server is AMERICAN_AMERICA.WE8ISO8859P1 .
DECLARE
fr_charset CONSTANT VARCHAR2(30) := 'WE8ISO8859P1';
to_charset VARCHAR2(30) := 'WE8MSWIN1252';
rawvar RAW(100);
v_rec VARCHAR2(100);
BEGIN
select x --value of x is chr(151)
into v_rec
from x;
rawvar := utl_raw.convert(UTL_RAW.CAST_TO_RAW(v_rec),
'AMERICAN_AMERICA.'||to_charset,
'AMERICAN_AMERICA.'||fr_charset);
dbms_output.put_line(utl_raw.cast_to_varchar2(rawvar));
message('AMERICAN_AMERICA.'||fr_charset);
message('AMERICAN_AMERICA.'||fr_charset);
:text_item5:=utl_raw.cast_to_varchar2(rawvar);
END;
|
|
|
|
|
|