MySQL 4.1 and Norwegian characters

[CiViX]

We have just migrated some webservers from RHEL3 running ARTs MySQL4.0 RPMs, too new servers with RHEL4 and native MySQL4.1.

After the migration Norwegian characters doesn't work in MySQL anymore. Norwegian charcters turn up as question marks: Tilbehør --> Tilbeh?r

I dumped the Tilbehør-table and used a search and replace tool to change all "Tilbehør" to "Tilbehor". I then dropped the Tilbehør-table and imported the edited SQL-dump. In the new table I have a column called TilbehorID. When I try to rename this to TilbehørID, I get the following error:

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ørID` MEDIUMINT(8) UNSIGNED NOT NULL AUTO_INCREMENT' at line 1

Do I have to downgrade to MySQL4.0 again, og is there a way to make MySQL 4.1 recognize and accept Norwegian characters?