mysql 通過echo的方式寫入數據庫 中文亂碼解決方案

?

echo "set names utf8;insert into xxx (path, sn, time, flag) values ('$wav', '$sn', '$secs', 'op');" | MYSQL
echo "set names utf8;insert into xxx (path, sn, time, flag) values ('$wav', '$sn', '$secs', 'op');"

?

前面增加 set names utf8;