Laravel 5.1 utf-8 saving to database

Question

I'm trying to save a record to database. When get value from input and save it to database there is no problem, like :

$request->input('name') is an input with value of 'سلام'

$provider->name = $request->input('name');
$provider->copyright_email = 'test@yahoo.com';
$provider->save();

But when i try give value from my controller problem appears. Name will save '?' into database :

$provider->name = 'سلام';
$provider->copyright_email = 'test@yahoo.com';
$provider->save();

I've already added this code to config/database.php :

'charset' => 'utf8',
'collation' => 'utf8_persian_ci',

@JaviStolz Thanks for replay. Yes. I'm using phpstorm and as you can see link below encoding configured to utf-8 [picture](http://imgur.com/soX7f1z) — A. Najafi, Sep 30 '15 at 14:48
read this https://www.jetbrains.com/phpstorm/help/file-encodings.html — patricio, Sep 30 '15 at 16:12
Where did you save this file? in your controller ? the file that contain "$provider->name = 'سلام';" , if yes, does your controller file is uni-coded? can you try to create the new file with Atom editor and try ? — Ihab Shoully, Sep 30 '15 at 17:31
@Shoully Thanks for replay. Yeah ! Just opened file with notepad++ and set it to encode utf-8 and after saving there was no problem. Don't know if i must do this manually for every single file which i use in my project, actually the picture and code i attached just was a test. — A. Najafi, Oct 01 '15 at 08:32
No, you don't have to do it manually, It's just your file was created with that character set, you can config PHPstorm to create any new file with utf-8 like @patricio said in the link. — Ihab Shoully, Oct 02 '15 at 14:58

Ihab Shoully · Accepted Answer · 2015-10-02T14:57:46.800

12

Check the file config/database.php :

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

I personally think you problem in you IDE, try to use Atom.

edited Oct 02 '15 at 14:57

answered Sep 30 '15 at 18:03

Ihab Shoully

"**1. ...**": Collation is only sorting algorithm, hence not relevant. "**2. ...**": is already, as OP mentioned Databese is operating sometimes. "**3. ...**": thanks, that was OP's real issue. – Top-Master Jun 05 '22 at 03:13

Habib · Answer 2 · 2019-09-25T11:56:57.003

1

config your database file to utf8mb4_unicode_ci

Check the file config/database.php :

'charset' => 'utf8', 'collation' => 'utf8mb4_unicode_ci',

edited Sep 25 '19 at 11:56

answered Mar 28 '16 at 06:18

Habib

Netwons · Answer 3 · 2020-11-29T07:49:12.197

1

im problem use

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

not work

but use into migration

$table->charset = 'utf8';
$table->collation = 'utf8_persian_ci';

edited Nov 29 '20 at 07:49

answered Nov 29 '20 at 07:43

Netwons

score 0 · Answer 4 · answered Jan 12 '18 at 18:28

I faced the same issue, the accepted answer dose not help me. Here how i solved the issue in this way:

Go to your table in your DB, check the 'Collation', change it to :

utf8mb4_unicode_ci

Apply this to each field in the table.

This may help somebody. :)

score 0 · Answer 5 · answered Feb 09 '20 at 08:24

0

also you can use below code for setting utf8 ->charset('utf8')

answered Feb 09 '20 at 08:24

Alireza Salehi

5 Answers5