Character set, Code Page 437
TobiasFeb 5 2007 — edited Feb 7 2007Hi!
Can someone explain why all characters is translated correct apart from Å=chr(143).
The file is create from forms 10GR2.
PROCEDURE print_l(sie_file_in IN client_text_io.FILE_TYPE, buff_in IN VARCHAR2) IS
trans_str VARCHAR2(20) := chr(143)||chr(142)||chr(153)||chr(134)||chr(132)||chr(148);
BEGIN
client_text_io.PUT_LINE(sie_fil_in,TRANSLATE(buff_in,'ÅÄÖåäö',trans_str));
END;
SELECT parameter, VALUE
FROM nls_database_parameters
WHERE parameter IN ('NLS_CHARACTERSET','NLS_NCHAR_CHARACTERSET')
PARAMETER VALUE
------------------------------ ----------------------------------------
NLS_CHARACTERSET WE8MSWIN1252
NLS_NCHAR_CHARACTERSET AL16UTF16
Regards
/Tobias