What encoding should i change it to? Currently the csv file is UTF-8, and I changed the column collation to utf8_general_ci because Latin_swedish was throwing exceptions on load.
Well good form would be to have it match the collation of your DB Tables but if standard you are getting exceptions

Mixing them usually has the end affect of strange characters as you have seen

All that I can find is this
https://www.zen-cart.com/tutorials/i...hp?article=396