Add UTF-8 BOM to csv - Mendix Forum

Add UTF-8 BOM to csv


When opening an exported CSV in MS notepad, the linefeeds are not displayed.

This is because of the lack of a so called UTF-8 BOM in the exported CSV file.

Please add this to the exported CSV so it will be readable in notepad as well.

1 answers

Yes this would be nice! UTF-8 with BOM is simply UTF-8 with a special character at the start of the String. As a workaround, you can add the BOM character yourself to your String and it will work. Opening the CSV file in Notepad++ shows the Encoding as UTF-8 with BOM, and opening the file in Excel correctly displays special characters. You can copy the BOM character from here: