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’).