As an alternate solution if you don't want to alter the MySQL table, your scripting language may have a function to convert the source data for the INSERT into the preferred character encoding, for example, PHP has mb_convert_encoding, which has resolved the issue for me: https://www.php.net/manual/en/function.mb-convert-encoding.php