Special characters replaced by ?

[Marka Ragnos]

Hi,

Most of the time i can solve my own problems however this one i cant do it on my own.

A few days ago my hosting company moved my forum to a new location.
I needed a dedicated server.

Everyting is ok but the special characters are replaced by an ? when you post something new.

The older posts are worse an example here and here

So i started searching these forums for an answer, it appears i'm not the first and i read something about the language settings and they are all ok.

Some say i need to edit something to my database.
But i dont know what.

I also dont have the backup database.

I hope someone can help me out.

Thanks,

[Colin F]

This is likely because the character set of the old database isn't the same as the character set of your new database.
I'd ask your host to make sure the character sets are the same, and then reimport the old database.

[Marka Ragnos]

They are not available this week and then would lose all posts from this week?

Can i change the settings myself? Or better yet where i can edit the character settings?

[Colin F]

The easiest way, which I described above, would require some server knowledge and appropriate access.

[Marka Ragnos]

The easiest way, which I described above, would require some server knowledge and appropriate access.

Could you take a look?

[Colin F]

I'd need to be able to view the old server as well, or at least know the settings that had, do you still have access to that?

[Marka Ragnos]

I'd need to be able to view the old server as well, or at least know the settings that had, do you still have access to that?

no

[GigaSb]

did you set character ?
i had "signs" problem and it solved when i set character to my forum.

[Marka Ragnos]

I'd need to be able to view the old server as well, or at least know the settings that had, do you still have access to that?

did you set character ?
i had "signs" problem and it solved when i set character to my forum.

You mean the HTML character set?

This one?
ISO-8859-1

[GigaSb]

yes

[Marka Ragnos]

it's always has been that code so it must be something in the database.

[Marka Ragnos]

In Mysql:

MySQL Karakterset: UTF-8 Unicode (utf8)

This was always the same setting...

i'ts really weird

[Marka Ragnos]

Sorry about this but i found a new error, the memberlist does not work.

MySQL Error : Illegal mix of collations (utf8_general_ci,COERCIBLE) and (latin1_swedish_ci,IMPLICIT) for operation 'find_in_set'
Error Number : 1267

http://bsg-online.be/forum/memberlist.php

Maybe this helps?

[Steve Machol]

This was almost certainly done when your host backed up and restored the database.

Does this happen wih new posts too, or just old ones?

[Marka Ragnos]

This was almost certainly done when your host backed up and restored the database.

Does this happen wih new posts too, or just old ones?

With new posts the special characters are replaced with a questionmark ?.

And the old posts are even worse, a few examples are in the first post.