Laravel save Arabic into MYSQL database

Question

I am building an application using Laravel framework. In the application there are two sets of language English and Arabic. When saving Arabic language field Name and Address data into MYSQL database. it saves the Arabic language in corrupted format.

name : ùùùù

What is that I am missing error

Answer 1

You should use unicode set of collation utf8_unicode_ci or utf8mb4_unicode_ci so it will support some specific languages chars.

probably utf8mb4_unicode_ci since it's the default for laravel.

more info and explanation about collation and the differences please check

What's the difference between utf8_general_ci and utf8_unicode_ci?