How to export Csv File With special characterst?

[udusat]

Hi Expert,

In my nridubai.com Website,there is one feature for admin - export all data in csv format.

But In my databse there are some companies contains non english characters like Äž .

When i export it into csv format,these characters replaces with strange characters.But when i try open that csv file with notepad,it showing proper.

Please help me to sort out the this exporting csv problem with special characters.

Thanks in advance.
And sorry for my poor english.

[nmaillet]

When you look at the exported CSV file in Notepad it's fine? So what program are you using to open the file, that gives the "replaced" characters? Are you using a C# program to parse it, or something like Excel?