Save CSV WITH BOM

Question

I have asp page which creates csv file. The problem is that this csv file is created as UTF-8 WITHOUT BOM and when I open it, some signs are not visible correctly. What should I change to save it as UTF-8 WITH BOM? If I convert it to UTF-8 WITh BOM manially in notepad++, it works.

Thanks.

    Response.Clear
    Response.ContentType = "application/vnd.ms-excel; charset=UTF-8;"
    Response.AddHeader "Content-Disposition", "attachment; filename=goodsTransfer.csv"
    Response.Charset = "UTF-8"
    Response.Write "all my data"
    Response.end

Answer 1

Try:

Response.Write(ChrW(65279) & "all my data")