Add more .env params for mysql collation

[tanthammar]

Every time I create a new project I have to go to config/database and update the collation.
It would be nice if we could get two more env variables.

DB_CHARSET
DB_COLLATION

Then the database.php could change to:

'mysql' => [
    //...
    'charset' => env('DB_CHARSET', 'utf8mb4'),
    'collation' => env('DB_COLLATION', 'utf8mb4_unicode_ci'),
    //...
]

[omarthegeek]

I believe that is possible now:

DB_CONNECTION=mysql
DB_HOST=127.0.0.1
DB_PORT=3306
DB_DATABASE=laravel
DB_USERNAME=root
DB_PASSWORD=
DB_COLLATION=utf8mb4_unicode_ci
DB_CHARSET=utf8mb4

and you can confirm the setting via tinker:

php artisank tinker
env("DB_COLLATION")
env("DB_CHARSET")

[nicolus]

Your test from tinker does not confirm that the environment variable is actually used, only that it was set. To make sure it's actually being used you should run :

DB::getConfig('collation');
DB::getConfig('charset');

And it does work starting with Laravel 11 since it was recently added : laravel/laravel@1ee7849

If you updated your project from a previous version make sure you update your database.php config to use those environement variables.

[omarthegeek]

True. If you already had created the tables, changing the env variable won't do anything unless you did a fresh migration or you'll manually need to change the table database configuration directly from the database itself.