Blank value for selected field when importing csv

[ivan.totev]

I am importing 40k of those rows. For about 300 of them it does not like the bundesland value and it is empty. I can see it has been set to this value and then removed.

What should I do to fix this? It is weird as it does it for some of those. The majorty of them are fine. I checked the utf formating , I checked if the values have spaces or anything else. What can I do to fix this? I am technical and I can make changes to the mautic code just not sure where I can look it up.

This is a select field and the values are as provided. I was thinking it is the umlauts in German but they are not as it does it for values that do not have them too.

[rcarabelli]

Probably is the collation in your csv file.
Open the csv file in a program like sublime text, check if the lines are showing ok, then save the file with a new character set, like utf8mb4 or specifically a collation like utf8mb4_0900_ai_ci probably.

After that, try importing again.