How to convert data with different charsets into other databases?

[magid]

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

[debasisdas]

You need to use the predefined function CONVERT.

This function converts a character string from one character set to another

CONVERT(<char>, <dest_char_set>, <source_char_set>)
 
SELECT CONVERT('� � � � � A B C D E','US7ASCII','WE8ISO8859P1')
FROM dual;

[magid]

it doesn't work correctly

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;

result is
EU?iY ?C?ICa? OCOaI?
E???? ?C?IC?? ?C??I?
EU?iY ?C?ICa? OCOaI?
E???? ?C?IC?? ?C??I?

please help me