How to convert â€“ to - in laravel

Question

Help me to fix this problem. The page should display - instead of â€“.

I already have <meta charset="utf-8" /> on my html <head>, I'm using visual studio code set to UTF-8, and the database. I'm using is mySQL, the version of my laravel is 5.4.

The â€“ comes from the database and i'm not allowed to alter it.

check your mysql database and table charset, is that utf8 or latin, if you are running migration through laravel by default charset is utf8mb4 and collection utf8mb4_unicode_ci — umefarooq, Jan 17 '19 at 05:46
the table and database are latin1_swedish_ci, they are not from laravel migration, it was from other web application. should i change the config/database.php to match it with latin? — boosted_duck, Jan 17 '19 at 05:49

score 0 · Answer 1 · answered Jan 17 '19 at 06:15

0

I got tired from debugging and decided to fix it using javascript

window.onload = function() {
     removeFunnyCharacters();
}


function removeFunnyCharacters() {
     var titles, arrTitles;
     titles = document.querySelectorAll('.c-project__title');
     arrTitles = Array.prototype.slice.call(titles);

     arrTitles.forEach(function(cur) {
         cur.innerHTML = cur.innerHTML.replace('â€“', '-');
     });
}

answered Jan 17 '19 at 06:15

boosted_duck

470
3
14

You do know that that’s a terrible and inadequate solution, right? – deceze Jan 17 '19 at 07:00
No, please please provide clean and better solution. – boosted_duck Jan 17 '19 at 07:13
That’s impossible to say without more details at this point. See the duplicate and http://kunststube.net/frontback for hints. – deceze Jan 17 '19 at 07:27

How to convert â€“ to - in laravel

1 Answers1