Convert DBF to MySQL that has German umlaut (ü ö ä, ß)

[aas1611]

I have a problem here.

I wanted to convert a DBF table into a MySQL table (using Navicat). This table has German names and words in it, which contain special characters ö, ä, ü, ß.
After converting, these characters appear as unknown, so some strange characters.

Under Navicat there's some kind of encoding when importing table, but I don't know which one.

How can I do this, with or without Navicat??

Please help!

 

[ericbrunson]

You'd need to figure out how the special characters are encoded, then convert that encoding to something MySQL supports. Without knowing the encoding of the original data, I can't say much else.