CODE EXAMPLE FOR PHP

laravel sql illegal collation

//laravel
fixed by adding 
'charset' => 'utf8mb4',
'collation' => 'utf8mb4_unicode_ci',
to config/database.php under mysql2 connection (your mysql db connection)