Linux in the MySQL programming when inserting Chinese garbled solution _php tips

Insert Chinese is garbled, tried a lot of methods, such as I first set vim setting to: Set Fileencoding=utf-8 does not work, then think about it, and vim does not matter
Then try the C # code, using the Encoding.UTF8.GetString () method, and then it's not right.
I was depressed, suddenly remembered to order MySQL setup problem???
So, sudo nano/etc/mysql/my.cnf
Insert the following red code, Default-character-set = UTF8, success, not garbled ~ ~ ~ Nothing encoding ...
# This is formally known as [Safe_mysqld]. Both versions are currently parsed.
[Mysqld_safe]
Socket =/var/run/mysqld/mysqld.sock
Nice = 0
[Mysqld]
#
# * Basic Settings
#
user = MySQL
Pid-file =/var/run/mysqld/mysqld.pid
Socket =/var/run/mysqld/mysqld.sock
Default-character-set = UTF8
Port = 3306
Basedir =/usr
DataDir =/var/lib/mysql
Tmpdir =/tmp
Language =/usr/share/mysql/english
Skip-external-locking