$insert->execute(10, '°C');
$insert->execute(80, '°F');
with error messages for both lines   
UTF-8 "\xB0" does not map to Unicode