Google App engine python writing csv in arabic

Question

I am trying to write a CSV in Arabic script. I have encoded the string to utf-8 and wrote it in the csv.

The problem is if I open the file in csv it shows strange characters like ?￠ù??2 ?3ù??ˉù?ù??a?′ ù??§ùù?ù? however if I open the file in notepad++ it shows the expected arabic text.

i checked notepad ++ and converted the encoding to utf-8 instead of utf-8 without BOM , now its working fine in csv reader(excel) too. so what should i do to set encoding to "utf-8 with BOM" in app engine

i am using unicodecsv.writer to write the csv

writer = unicodecsv.writer(self.response.out)
row = []
row.append(transaction.name.encode('utf8'))
writer.writerow(row)

the data to be written is taken from the datastore

Answer 1

Waitting for answers