CODEWITHSUNDEEP
phpmysqldatabaselaravelutf-8
Maha Dev
Maha Dev

Reputation: 3965

Laravel 5 eloquent not storing special characters in database

I am using laravel 5.2 and here are my database configuration settings:

'charset' => 'utf8',
'collation' => 'utf8_general_ci',

I have also tried 'utf8_unicode_ci' as collation but its also not working.

Use case: This is the text I am trying to insert:

$str = "Après 9 mois passés dans le"

but this is storing:

Après 9 mois passés dans le

Upvotes: 5

Views: 8856

Answers (2)

apokryfos
apokryfos

Reputation: 40730

What you're seeing there is the text being replaced with HTML entities this usually is the result of text coming directly from an HTML source (either a form with text that was previously converted to htmlentities or an other source).

The ideal solution here is to ensure that the text is not received as HTML entity encoded, however if this is not an option (which it very often is not), you can use:

 $decoded = html_entity_decode($text);

to decode the entities into their actual characters before you insert them.

A bit of trivia:

You don't actually need to encode all characters to their corresponding entities to display on HTML as long as you're properly sending Unicode text. This is why PHP has 2 different functions htmlspecialchars and htmlentities where the first function only encodes what is necessary to encode in order to not break HTML (those 5 characters listed in the manual, <, >, &, " and ') while the second one encodes everything based on the linked table.

Upvotes: 2

Bara&#39; ayyash
Bara&#39; ayyash

Reputation: 1925

In your Database.php insert : 

'charset'   => 'utf8',
'collation' => 'utf8_unicode_ci',

This should allow you from saving the string in the format you want.

And please make sure that your MySQL is set to utf8

Upvotes: 0

Related Questions