How to make laravel read foreign language characters from mysql database?

Question

It is converting a readable character to "á‹á‹µ á‹°áŠ•á‰ áŠ›". I am using "utf-8" for the columns of the table

make sure in your database config file you have 'charset' => 'utf8mb4', 'collation' => 'utf8mb4_unicode_ci', these. — Chamara Abeysekara
– Chamara Abeysekara, Commented Apr 10, 2019 at 3:17
Did you try Database charset utf8 and Database collation utf8_general_ci ? — Harun
– Harun, Commented Apr 10, 2019 at 4:59
You can try following question feedback stackoverflow question — Surender Singh Rawat
– Surender Singh Rawat, Commented Apr 12, 2019 at 11:22

hazem ali · Accepted Answer · 2019-04-13 11:39:02Z

3

+25

First make sure as the comments said the database character is set to be utf8mb4_unicode_ci or utf8_general_ci the first charset is for the emojis anyway back to the issue .. make sure that the php files is set to be utf8 too .. by using a modern editor like phpstorm or vscode or sublime .. you might try to use tinker .. by typing php artisan tinker in your terminal window or command line if you're using widows -> then try to add a record in your database with the non-english language then check it again .. if it doesn't convert to this gibberish so the the problem is not with the database charset is with files as I said.

answered Apr 13, 2019 at 11:39

hazem ali

3012 silver badges7 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Tiago Gouvêa · Accepted Answer · 2019-04-13 14:48:23Z

0

You should ensure that your .env file has the following attributes:

DB_CHARSET=utf8
DB_COLLATION=utf8

It will force laravel to use this charset and collation on all queries it runs.

answered Apr 13, 2019 at 14:48

Tiago Gouvêa

17.1k6 gold badges86 silver badges83 bronze badges

Collectives™ on Stack Overflow

How to make laravel read foreign language characters from mysql database?

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related