Eloquent Special Chars Issue

Question

I have a HTML variable an it contains characters like "●","❒","◉","⭕","■". And i have to store these in MYSQL database. I am using Capsule for this without laravel. There is no problem with printing these characters but when put them into database they show up like this "â—","Ã¢Â—Â". I dont want to remove these characters.

I have tried all html escape functions.

Edit: My database's charset is utf8_general_ci.

Thank you so much. – Hasan Ali Balcıoğlu Aug 16 '19 at 15:57 — Hasan Ali Balcıoğlu, Aug 16 '19 at 15:57

score 0 · Accepted Answer · answered Aug 16 '19 at 15:55

0

 'default' => array(
        'driver'    => 'mysql',
        'host'      => 'localhost',
        'database'  => 'db',
        'username'  => 'root',
        'password'  => '',
        'charset'   => 'utf8', // <-- that fixed my problem
        'collation' => 'utf8_general_ci'  //  <-- that fixed my problem
    ),

I have added charset to eloquent connection settings and it fixed my problem.

answered Aug 16 '19 at 15:55

Hasan Ali Balcıoğlu

1
1
1

By the way the correct charset for UTF-8 is `utf8mb4_general_ci` not `utf8_general_ci` – Dharman Aug 16 '19 at 22:17

Eloquent Special Chars Issue

1 Answers1