By pnikosis on

I have a spanish Drupal site, today I entered to the site, and I saw that the special characters (accents for example) changed, like if the database changed its collation. The characters changed this way:

¡ = ¡
ó = ó
ñ = ñ
à = í
á = a
ú = ú
é = é
¿ = ¿

Any clues?

Thanks!

I have a 4.7.4 Drupal version

⋅ Categories: Drupal 4.7.x

Comments

parvell’s picture

parvell commented

It happens to me too with mysql 4.1. I solved dumping the database with collation option ("CHARACTER SET utf8" I think to remember) with UTF-8 and re-dump it again back with the same collation option (UTF-8)

whereisian’s picture

whereisian commented

Happened after a migration to a different server. Running Drupal 4.7.3. At some point mysql collation swithced to utf_swedish_ci. I changed it back to utf_general_ci and subsequent posts are being stored correctly. However, I have to come up with a way to fix the previous entries. I'm going to attempt something like the snippet here or here.