Special characters on thread titles gone after upgrade

[tidesson]

Hello I'm a VB newbie with a small problem. I was using vb version 4.0.8 and recently upgraded it to 4.1.2. To do this, I created a new database and backed up there all the content of my forum before doing the upgrade in case anything went wrong. The upgrade to 4.1.2 in this mirror of my forum went OK, didn't give me any kind of errors, and the forum worked fine. However I realized soon afterwards that the special characters on the thread title links were gone. I'm spanish and I'm using vbulletin with a spanish language pack; there's a lot of thread titles with 'special' characters like 'ñ', or 'á', 'é', 'í', 'ó', 'ú'. Those letters are not showing properly anymore. One quick example:

thread titled "Enredados BSO Español"

is showing as "Enredados BSO Español"

This only happens in the thread titles and not anywhere else in the whole forum, at least not that I know of. I've been looking around but can't find a solution for this. I could go and manually edit all the thread titles, but there's a lot and I want to know whats the cause of this and if there's any quick fix for this issue.

Thank you in advance

[Zachery]

Are you using any third party addons?

[tidesson]

Yes I'm using a few, but how do they affect special characters in thread titles exactly? The ones im using are: marco1 hide all, ae multiple login detection, post thank you hack, glowhost spam-o-matic, check similar threads before posting a new one, yet another mass private message system, and who has read a thread.

[your24hourstore]

more than likely just need to run maintenance and Fix Unique Indexes
might run some other Rebuild Thread Information

[tidesson]

Originally Posted by your24hourstore

more than likely just need to run maintenance and Fix Unique Indexes
might run some other Rebuild Thread Information

Thanks for the insight, gonna try and do that now

EDIT: nope, didn't work. But thanks, I didn't try that yet

[Paul M]

Looks like a utf8 issue - was the new database defined as utf8 ?

[tidesson]

Originally Posted by Paul M

Looks like a utf8 issue - was the new database defined as utf8 ?

Both the old db and the new one are set like this:

Language: Spanish (es-utf-8)
MySQL charset: UTF-8 Unicode (utf8)
MySQL connections: utf8_general_ci

I don't know much about databases but I believe it's the correct one. It's the default settings set by my service provider.

Again, this problem occured once I updated my mirror database to 4.1.2. The mirror itself, when running on 4.0.8 didn't have this problem. So whatever it is, it got bogus after running the upgrade.php script.