What is the specific function of SET NAMES UTF8?

In order to prevent garbled characters, I have set up several character sets for db:

<code>        mysqli_query($db,"SET NAMES UTF8");
        mysqli_query($db,"set character_set_client=utf8");
        mysqli_query($db,"set character_set_connection=utf8");
        mysqli_query($db,"set character_set_results=utf8");</code>

But I saw an article saying this:
http://zhangxugg-163-com.iteye.com/blog/1835721

According to the above description, is one SET NAMES UTF8 already equal to set character_set_client=utf8; set character_set_connection=utf8; set character_set_results=utf8; What about these three?

Let’s discuss
.`

Reply content:

In order to prevent garbled characters, I have set up several character sets for db:

<code>        mysqli_query($db,"SET NAMES UTF8");
        mysqli_query($db,"set character_set_client=utf8");
        mysqli_query($db,"set character_set_connection=utf8");
        mysqli_query($db,"set character_set_results=utf8");</code>

But I saw an article saying this:
http://zhangxugg-163-com.iteye.com/blog/1835721

According to the above description, is one SET NAMES UTF8 already equal to set character_set_client=utf8; set character_set_connection=utf8; set character_set_results=utf8; What about these three?

Let’s discuss
.`

<code>set NAMES utf8
show variables like "character_set_%"</code>

The operation display is like this

As answered above, the three values ​​of character_set_client/character_set_connection/character_set_results have been changed

Yes, one command is equal to the 3 items you listed. The main thing is to ensure that the encoding is consistent and not garbled