Detect mixed-up encoding in PHP and make everyting Windows 1252

I’ve got a CSV file with mixed up encoded strings:

mb_detect_encoding seems to detect UTF8 but decoded string still shows weird characters

I’m struggling to detect the right encoding to insert an UTF8 CSV dataset to a database.