By coral on

I have used Drupal for over a year, and i installed the new version for about a week ago. It worked in One week. Then all the characthers (the swedish å ä ö) went wild. Just by themself

http://www.neosoft.se/ - What is wrong?

/Jonta

⋅ Categories: Drupal 4.7.x

Comments

netbjarne’s picture

netbjarne commented

It happened all the sudden, on several different sites.

Funny thing though, only old content is hit by this thing, new content I created shows up fine.

Example: www.drupaldanmark.dk

Could this be a host issue? - I'm using surftown

hitka’s picture

hitka commented

Perhaps your host upgraded mysql from version 4.0x to 4.1+. The mysql versions prior to 4.1 do not support unicode (neither database-specific encodings nor collations), so drupal saves utf-8 data as if they were in iso-8859-1.
To migrate drupal from mysql 4.0 to 4.1 (or 5.0) you need to export your db as iso-8859-1 and then import it as utf-8. See for example http://drupal.org/node/71289

netbjarne’s picture

netbjarne commented

Thats the version of my mysql db. Currently.

The fun thing is - today, all my sites hosted at surftown, was down - unable to connect to the database... Now, a bit later, they are all up again. All the OLD postings, are now again shown correctly, with æ ø å and other national sillyness, but all the NEW posts are now shown incorrectly.

This smells quite heavily like some db admin applying and update, noticing problems with national charaters, and rolling back to a previous version of mysql. But thats only guesswork...

But thanks for the hint! - I can add, that in phpmyadmin you can see the version of the mysql used. The mysql SHOW VARIABLES command can also be used.