Can not insert UTF8 to Database MySQL in Linux

Question

When create table, I have setted charset = utf8.

I create 1 store procedure to insert data to database.

1. When insert data UTF8 to Database on Window, it works OK.(Display data correctly)
2. But it doesnot work in Linux.(Display data not correctly)

The strange thing is insert UTF8 work fine in window, but when i deploy MySQL in linux, when insert data to database it insert wrong UTF8 value.

Thanks for help

Edit: Update more detail follow comment of @Col. Shrapnel

Answer 1

most probably you didn't specify client character set by issuing SET NAMES UTF8 query

but there can be other problems - your database or a web page may be not in the utf-8

Answer 2

You should start mysql console with --default-character-set=utf8:

mysql --default-character-set=utf8 -uyour_user -p

Answer 3

I just found a solution for my problem: Edit file my.cnf under /etc/my.cnf as below:

[mysqld]
default-character-set=utf8
default-collation=utf8_general_ci
character-set-server=utf8
collation-server=utf8_general_ci
init-connect='SET NAMES utf8'

[client]
default-character-set=utf8

But i still confuse why this bug occur in Linux, not in Window.