Update PDO example - SET NAMES utf8mb4

[odan]

SET NAMES indicates what character set the client will use to send SQL statements to the server. Thus, SET NAMES 'utf8mb4' tells the server, “future incoming messages from this client are in character set utf8mb4. It also specifies the character set that the server should use for sending results back to the client. (For example, it indicates what character set to use for column values if you use a SELECT statement.)

https://dev.mysql.com/doc/refman/5.7/en/charset-connection.html

I would suggest to update the PDO example like this:

$link = new PDO(
    'mysql:host=your-hostname;dbname=your-db;charset=utf8mb4',
    'your-username',
    'your-password',
    array(
        PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,
        PDO::ATTR_PERSISTENT => false,
        PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES utf8mb4 COLLATE utf8mb4_unicode_ci"
    )
);

What do you think?

Edit: Added COLLATE utf8mb4_unicode_ci

[jaylinski]

Laravel is also using this command:

https://github.com/laravel/framework/blob/v5.4.14/src/Illuminate/Database/Connectors/MySqlConnector.php#L56

By default they do it like this: set names utf8mb4 collate utf8mb4_unicode_ci.

[aarie33]

I am so helped with this answer
I was confused with this issue, I tried many ways to fix it.
But finally, my actual problem is about the syntax, this syntax is the best that I can use

Thank you

[tgvishal]

'mysql:host=your-hostname;dbname=your-db;charset=utf8mb4',
This worked for me