Characters missing while using write CSV using the encoding "iso-8859-1"

Hello Everyone,

I am writing into a CSV file and using the encoding “iso-8859-1”. It is writing everything except some special characters like “ä”, “ü”, “ö”. When I open the CSV in notepad i see that it has encoding “UTF-8”. I have another CSV where the same special characters were written correctly and when i open that on notepad i see it has encoding “ANSI”.

Can someone please help me to write the special characters properly in the CSV?

Thanks in advance


Can you share the above file? (It’s no problem if dummy data)