UTF-8 settings

[Akabane]

Hello,

We recently converted our DB to UTF-8. We still see tons of bugs and support says it may be related to the following problem :
We can't figure how to use this settings in the global conf :


$INFO['sql_charset'] = 'utf8';


Sadly, when using this, the DB crash right away... :x (well, we get IPB error DB screen "Your settings could not be read by IP.Board. This is a fatal error and IP.Board cannot function while this issue persists.")

And it does crash too on a new server with a brand new UTF8 install...
It seems we forgot to setup something server side, any idea what should that be? What parameters are crucial for mysql when using UTF-8 ?

Any idea is welcome. ;)

[Akabane]

Shameless bump :/

[PeterUK]

What kind of access do you have to your server? Root?

Check your my.cnf file and see what collation_server and character_set_server are equal to.

Then check your php.ini and see what default_charset is equal to.

This will check PHP and MySQL are talking to eachother using UTF-8.

[Akabane]

Thanks, I'll try that on one of the servers. The other one, sadly, host too many non-utf8 websites. :(