[illuminate/database] Setting the MySQL charset directly via DSN

[jaylinski]

Hi!

The illuminate/database-code currently sets the configured MySQL database-charset via a separate SET NAMES-query:

• https://github.com/laravel/framework/blob/8.x/src/Illuminate/Database/Connectors/MySqlConnector.php#L32
• https://github.com/laravel/framework/blob/8.x/src/Illuminate/Database/Connectors/MySqlConnector.php#L76

PHP warns about doing this in their docs, because it can affect param-quoting in a negative way:

https://www.php.net/manual/en/mysqlinfo.concepts.charset.php

Can anyone tell me why it is done this way? Could this be improved or is there a specific reason for doing it like that?