I have a unit in php which gets tv-guide data from several api's. This data sometimes contains special characters like: carrière
. I put all the tv-guide data in a database, but the special characters get mangled up and change to a ?
.
I think it is not a database problem, because i have set the database to utf8mb4_unicode and also all tables and col's.
I tried this:
iconv('UTF-8', 'ISO-8859-1//TRANSLIT//IGNORE', $input);
but that doesnt seem to make any difference..