Software FAQ » Database » MySQL Server » Swedish characters (å, ä and ö) transformed to question mark

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
Bookmark and Share
Convert week number and year to date range   Oracledbconsole service not starting  
Problem: Update tables of  another database.   Problem: Cannot connect to SQL Server 2005 from anywhere but localhost.  
How do I do a replace text in a pdf?   route to new backend server not found  
IE7 Menu Bar keeps disappearing after resarting IE.   htaccess redirect from sub directory  
Add PHP to Web Matrix   Active Directory Modified Account History  
how to pull data from master dataset in SAS   Display multiple records in form using a group by query  
Using array to condition looping through another array   Fading songs (MP3's) when recording . . how?  
Recover Deleted email   How do you convert 196/256 bit MP3s to 128 bit MP3s?  
Problem: Warning: invalid error callback in C:\wamp\www\banners\libs\P<wbr />EAR\PEAR.p<wbr />hp on line 362   Write error on ntfs file system on ubuntu 8.04  
Problem: C#: what is the efficient way to change the value for a key in System.Collections.Generic<wbr />.Dictionar<wbr />y?   How fix a corrupted Windows Media Player Library?