I am sending a report from a unix shell script that contains chinese characters. When I open the CSV report in plaintext editor like textmate I can see the chinese characters but when I open CSV report file in Excel I don't see the chinese characters, but some gibberish.How do I tell excel that the file contains Chinese charset ?Here is the code that sends mail and attaches the CSV file.send_mail() {v_mailpart=ZZ_/afg6432dfgkl.94531qecho Mail to be sent to $RPT_SEND_TOecho To: $RPT_SEND_TOSubject: Blah Report as of $report_date_format;Content-Type: multipart/mixed; boundary=\$v_mailpart\MIME-Version: 1.0This is a multi-part message in MIME format.--$v_mailpartContent-Type: text/htmlContent-Disposition: inline<html><body><p>Hi All,<p>Please find attached, the daily report <p>Thanks,<br/>Blah Team</br/><br/><br/></p><p>NOTE: This is an auto-generated email. Do not reply to it. Please send an email to blah-group@mycompany.com in case of any issues.<p></body></html>--$v_mailpartContent-Transfer-Encoding:UTF-8;Content-Type: text/plain;charset=\UTF-8\;Content-Disposition: attachment; filename=blah-report.csv`cat $spool_file5` | /usr/sbin/sendmail -t}
How to make excel interpret Chinese characters in CSV file
shell script;csv;sendmail