Insert accented characters into field with utf8mb4_unicode_ci collation

[mmnpinto]

I'm trying to import a CSV to insert into a table and I'm having trouble inserting accented characters like 'NÃO ACERTA' which is converted to 'N?O ACERTA' What am I doing wrong?

[franse]

Hello!
Collation seems fine, can you test inserting an unique value NÃO without repeat/csv just for discard mysql thing?

Also, have you opened your csv with notepad and check if Ã is there?

[mmnpinto]

direct insertion works well

When I open the CSV in Notepad++, everything appears ok