> ## Content Index
> Fetch the complete content index at: https://michaelbrooks.co.uk/llms.txt
> Use this file to discover other available public pages before exploring further.

# UTF-8 causing problems for Social and Email Websites Laravel
- URL: https://michaelbrooks.co.uk/utf-8-causing-problems-for-social-and-email-websites-laravel/
- Published: 2024-10-10T07:19:07.000Z
- Updated: 2024-10-10T07:19:07.000Z
- Author: Michael Brooks
- Tags: laravel, php, #wordpress

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. 🙂