I've got an excel importer for my website, which seems to be working fine - up until I found a row which has apostrophes, and it's trying to save the information into the database using �.
Example:
Branches in Vava’u, Haapai, ‘Eua and Niuatoputapu
Changes to:
Branches in Vava�u, Haapai, �Eua and Niuatoputapu
Is there any way I can fix this easily within php?
Try to replace the � by ' before saving in database. Sometimes MS Excel uses other chars with different codes for special chars (non printable ASCII codes).
Vava’u - contains 0x19 char code, use 0x27 instead
‘Eua - contains 0x18 char code, use 0x27 instead