Laravel替换数据库中的Unicode字符

Question

I stored some hours from Google Places and little did I know it brought in some longer dashes (\u2013) and I'd like to loop through and convert anything in the database that is a unicode string into a normal string, as when I retrieve these hours I can't explode them via

explode(' - ', $hours);

What's the best way to do this in Laravel/MySQL/PHP?

Answer 1

You can use an SQL query for that:

UPDATE `table`
SET `column`=REPLACE(`column`, '–', '-')