title: How to convert data with different charsets into other databases?
body: <p>hi
  we want to use database link to connect a Database for operating the select,update or ... commands,our destination database is WE8ISO8859P1 and current database is AR8MSWIN1256 cahrset, but when we operate a command to view data,all NonEnglish characters appear odd wich we can not recognize the appeared text, also if we use convert function no change would make, please help us to view right charachters with our database link.
  thanks </p>
  
  <p>it doesnt work with convert founction </p>
  
  <p>select convert(menu_name,'US7ASCII','WE8ISO8859P1'),
  convert(menu_name,'ar8mswin1256','WE8ISO8859P1'),
  convert((convert(menu_name,'US7ASCII','WE8ISO8859P 1')),'ar8mswin1256','WE8ISO8859P1'),
  menu_name
  from T$R_MENU@"TO201.US.ORACLE.COM"
  WHERE MENU_ID=601011;</p>
  
  <p>result is
  EU?iY ?C?ICa? OCOaI?
  E???? ?C?IC?? ?C??I?
  EU?iY ?C?ICa? OCOaI?
  E???? ?C?IC?? ?C??I?</p>