Skip to main content

Posts

Showing posts with the label Laravel

[SOLVED] Illuminate\Database\QueryException : SQLSTATE[42000]: Syntax error or access violation: 1115 Unknown character set: 'utf8mb4' (SQL: select * from information_schema.tables where table_schema = laravel_blog and table_name = migrations)

Hal ini disebabkan karena perbedaan character set yang digunakan antara database (Mysql) dengan setting pada Laravel. Solusi: buka file config\database.php pada bagian connection, ubah:         'mysql' => [ ...             'charset' => 'utf8mb4',             'collation' => 'utf8mb4_unicode_ci', ...         ], menjadi         'mysql' => [ ...             'charset' => ' utf8 ',             'collation' => ' utf8_unicode_ci ', ...         ],