Weird characters

Im working mostly in a language that has umlauts and dots (swedish) above vowels. I have major issues with the characters å, ä, ö. I type them out, they are fine. I look at my mysql on the server, the character is correct. I export a csv-file from my server and open it in textedit or numbers and suddenly those characters are garbled. Completely garbled.

I have to search and replace to fix the characters back to what they should be before I can upload to the server again. Mysql is set to run Swedish Characters, so is the server. But I still get this issue.

Could anyone please help me and tell me what to do? I'm working on a huge project right now and really need this working ASAP.

Cheers

Message was edited by: sagalady