RC4 - IMPORTANT BUG - Problem with latin letters

There is a major bug when it comes to sites that are using latin letters and characters such as é á ç ã è etc. The words / letters that are in the language file are ok. The problem is with the content that is kept in the MySQl database, such as users blogs and the site quotes. The look at this page and you will see what I am talking about:

http://www.amigocristao.com/blogs/entry/Cerveja-o-sentido-da-vida

Notice the weird characters and letters that show in the post and in the quote at the top. They were OK for a few day but them it started getting like this. After the last update it really affected everything.

Can you please have this fix as it is indispensable for us. Thanks

Ticket added: http://www.boonex.com/trac/dolphin/ticket/1653

can not reproduce, everything is ok on demo site.

Maybe you have done some manipulation with your database ? like changing default database encoding and/or collation ?

there are many posts on demo before/ and after update - and they look great

Thanks Michel,

I think that this has to do with the fact that the database fields are formatted UTF-8 and that for you to have the special characters to work you need iso-8859-1. I might be wrong but I really hope that they can get this sorted.

Hi Alex,

I haven't done no manipulation to the database at all. This is what I have done that hopefully with help you in finding a solution to the problem. During the upgrade from RC3 to RC4 I created a full back up of my files and database.

Our site has a Portuguese language file that I added to the upgrade/files folder (as described by the update procedure). The problem is that when I ran the update I got a massive error message from the script. So what I did was to delete everything and restore the files and the database. This time I ran the upgrade without adding the lang_pt.php file to the upgrade/files folder. The upgrade was a success. In order to get my portuguese language file updated, I deleted it through the languages in the admin, and then imported it back through the same place. I recompiled and everything was ok. So I do not know how this could have affected the stuff that is stored in the database, because the text that is in the language file shows perfectly.

Please help

I suppose that during upgrade you backup and restored your database !

Most probably that during backup and restoration something went wrong with encoding ! Like you saves file in another encoding .. or during restoration you restore file with another encoding than during saving ...

RC3-RC4 upgrade script do almost nothing with database .. it can not broke your database encoding at all !