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

MBP, Mac OS X (10.5.7)

Posted on May 18, 2009 1:08 AM

Reply
16 replies

Jun 19, 2009 11:45 AM in response to sagalady

Just want to add that I believe I am having the same problem--seems as if the encoding vanishes in the process of importing a list into another program. I have tried all different varieties of encoding, and the Text edit as well as the original documents appear correct (Spanish accents and such not garbled.) Then, when I import the list into another program, they become garbled. But, like the poster of this question, I too can enter the correct text into the object program manually. I suspect, but am not sure, that this is a very recent development.

Jun 19, 2009 3:03 PM in response to Tom Gewecke

I am making word lists which are in both Spanish and English. I then am trying to transfer these lists into the Dictionary part of the program Crossword Express. I had to use word processors to find all the previous errors in the word lists (errors due to encoding, and garbled text)-- and I replaced the characters with the correct ones this way. Then I began the movement to Crossword Express. Because Crossword Express wants it's Mac users to use Text Edit and plain text, I pasted the revisions from the word processors (Text Wrangler and Mellel) into Text Edit, and proceeded. All goes well until I open the dictionary in Crossword Express, and find the text garbled.

(I have also written to the creator of Crossword Express, and I'll probably hear from him in a day or two.)

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

Weird characters

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.