I’ve been developing a couple of projects which use UTF-8 encoding on my databases, but have found that this has been problematic recently. Mobile phones and tablets now use emoticons which can cause problems for us UTF-8 users.

So how do we fix this issue?

Well let me explain below…

Recently, I was testing out one of my creations and sent a message using an emoticon. Laravel started spitting out errors and it confused me as to why this was happening. After a quick search, I found that in order to save these emoticons to the database, I need to change my encoding from UTF-8 to UTF8MB4.

I found a little snippet which allowed me to change my tables encoding

ALTER DATABASE database_name CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci;

Fantastic I thought, I did this with every table which needed it and then tested my app again, I got the same error?!? 😮

One thing I missed out, was that I need to set Laravel’s settings to the same encoding as my database. Move on over to app/config/database.php and you will find the ‘connections’ array. I’m using mysql, and I found just what I was looking for…

‘charset’ => ‘utf8’,
‘collation’ => ‘utf8’,

Change this to…

‘charset’ => ‘utf8mb4’,
‘collation’ => ‘utf8mb4_general_ci’

And you are done. Let me know if you still have any problems and your stories with how you managed to fix this issue. 🙂


Leave a Reply

Your email address will not be published. Required fields are marked *

%d bloggers like this: