Spanish Character Problem

[muammar]

Hi, some time ago I had a problem with my server. Now, I am trying to install serendipity again using the last database and the last version of serendipity I used at that time (1.1.2). The problem is that Spanish Characters are shown as a mess. Look at this:

http://muammar.me/blog/

I have tried lots of stuff like just dump data into Databases created from a pristine instalation. I have tried using all the last Database and none of the tries mentioned above have worked for me.

I did other try like adding in /etc/apache2/conf.d/charset this:

AddDefaultCharset ISO-8859-1

It worked at the first time. But when I change something in the configuration, everything gets bad again.

Could somebody point me out to a solution?

PS. Don't look at the missing plugins, I haven't installed them, yet.

[garvinhicking]

Hi!

This error seems to happen because your DB entries are stored as UTF-8 characters, but are emitted using the ISO charset, which then are displayed again as UTF-8 characters.

Try to enable/disable the option "Use database charset" within the s9y admin configuration in the database section, this might help.

Did I understand you right, you installed s9y on top of a database that already existed? Did this database previously also use UTF-8? If not, you might want to configure your s9y to ISO-8859-1 again.

Regards,
Garvin

[muammar]

Hi garvinhicking,

I solved the problem converting the database from utf-8 to ISO-8859-1 using:

iconv --from-code=UTF-8 --to-code=ISO-8859-1 old.sql > new.sql

Then I dumped the database and I proceeded to do what you said about enabling/disabling the option "Use database charset" within the s9y admin configuration in the database section.

Thanks for your help.

Cheers,

PS. BTW, nice pics@flickr