hi i have a problem with export my output database i have writed this script :
#!/bin/bash
clear
export NLS_LANG=.AL32UTF8
cd /home/oracle ; . db-env; sqlplus -s / as sysdba << EOF >/dev/null
spool /tmp/result.txt replace
@/tmp/script.sql
spool off
EOF
echo -e 'this is test' | mailx -v -s "test" -S smtp=smtp://mail.company.com -S from="my company" -a /tmp/result.txt a.a@company.ir > /dev/null 2>&1&
this script automatically connect to database and select from a table and save the out put to result.txt file and then mail result.txt file now my problem is when i attached this file to mail and send some of my datat on taht file are arabic and i can not see arabic data in result.txt file instead of arabic word see ??????? now how can solve my problem ? best regards Babak