Unable to query with Chinese character

[Lamarche Lam]

Hello everyone,
I'm new to MySQL so I was practicing with a MySQL tutorial

There was a question in this tutorial requiring us to query a record using LIKE operator so I did it as:

select
Tname
from Teacher
where Tname like '李%';

and the result was Tname: (nothing showed up except the column name).
(All databases and tables in this tutorial was set to utf8 before any query was performed)



Some suggested me to set the encoding in the configuration file (my.cnf) into utf8 and so I add:

[client]
default-character-set=utf8

[mysql]
default-character-set=utf8

[mysqld]
character-set-server=utf8

in the my.cnf file and apply it in the system preference panel.




However, it does't work at all.
Could somebody please show me a way out of this?
Thank you so much.