Remove Special Characters in csv

How to remove special characters like � while importing data from CSV to database?

I have also faced the same issue while importing data into my database from a CSV. Instead of removing the characters I decoded the unsupported characters. Try the way mentioned below.

special or unsupported characters can be converted or decoded using ‘mb_convert_encoding’ in php.

mb_convert_encoding(‘YOUR_STRING’, ‘UTF-8’, ‘Windows-1252’).

1 Like