Swedish characters (å, ä and ö) transformed to question mark
I'm running Suse 10, setup for the Swedish language, keyboard and characters. It is working smoothly, showing appropriate characters everywhere EXCEPT with MySQL.
I'll give you one example: I have this sql file. I check it in Kate and find what I expect to find; å ä and ö show up. When I load the sql-file into MySQL using phpMyAdmin (browser: Firefox) and check the database output by using the very same browser, it shows '?' instead of the characters I had expected. If I make a change to the database, again using phpMyAdmin, and change one item in one line just to check what happens (I changed the original input from 'Marica* to 'ÅåÄäÖö') it shows up as 'ÅåÄäÖö'. (No ' used)
To say the least, I'm bewildered.
Where have I gone wrong?
Solution: Swedish characters (å, ä and ö) transformed to question mark