Problem with German words using Umlaut (like über)

4 views
Skip to first unread message

Jason

unread,
May 22, 2009, 6:28:22 PM5/22/09
to iPhoneFlashCards
I recently installed the FlashCards application to work on GRE words
and also my German vocabulary. I am really, really enjoying it and you
should be proud of a great app! However I recently tried to upload a
CSV full of German vocabulary and whenever the site encounters a word
with an umlaut (such as "fängt") the word cuts off right before the
umlaut - so you only get "f" (which is not so usable). You can see my
attempt at http://flashcards.red5dev.com/cardsets/523. The same thing
happens when you use an ess-tset (ß). I am almost 100% sure that my
encoding is correct - do you know a way around this?

Thanks
Jason

Jason

unread,
May 22, 2009, 8:27:04 PM5/22/09
to iPhoneFlashCards
Actually, never mind - it is working now! I actually did have it in
the wrong encoding, Excel on the mac seems to keep putting the file
into MacRoman and not UTF-8.
Jason

On May 22, 6:28 pm, Jason <jasonlus...@gmail.com> wrote:
> I recently installed the FlashCards application to work on GRE words
> and also my German vocabulary. I am really, really enjoying it and you
> should be proud of a great app! However I recently tried to upload a
> CSV full of German vocabulary and whenever the site encounters a word
> with an umlaut (such as "fängt") the word cuts off right before the
> umlaut - so you only get "f" (which is not so usable). You can see my
> attempt athttp://flashcards.red5dev.com/cardsets/523. The same thing

Jason

unread,
May 26, 2009, 5:14:55 PM5/26/09
to iPhoneFlashCards
After doing some more research on this subject, I discovered that
Excel on the Mac will not export CSV files with UTF-8 encoding - it
will only save with MacRoman or Latin encoding. So, with a Mac, one
has to either not use Excel, or use iconv to convert the Excel CSV
file. The command I used (if anyone else is looking for a solution to
this problem) was:

iconv -f MacRoman -t UTF-8 oldfile.csv > newfile.csv

Is there any plan to support other encodings so that we don't have to
use such a workaround?

Thanks,
Jason
Reply all
Reply to author
Forward
0 new messages