Mysql 4.1 wrong char

[adapter]

Hi

i have upgrade my server from mysql 4.0 to 4.1 but now a lot of site display a wrong text, all the letter with à è ù are as "ù " how can i fix this problem?

Thanks

 

[casey]

Try adding

[mysqld]
init-connect=SET NAMES binary

to my.cnf

Then restart mysql.

 

[adapter]

I have try with init-connect=SET NAMES utf8 but i still have the same error

 

[casey]

UTF-8 won't work, because those characters are ISO. Did you try "binary"?

 

[dyrer]

which one my.cnf i have /etc/my.cnf and /user/local/cpanel/whostmgr

My joomla installation creates latin1_swedish_ci collation

 

[casey]

which one my.cnf i have /etc/my.cnf and /user/local/cpanel/whostmgr

My joomla installation creates latin1_swedish_ci collation

/etc/my.cnf

latin1_swedish_ci collations are exactly why utf-8 won't work. Unless you want to convert your database to utf-8, which could be messy if there are special keys within the database.

 

[dyrer]

how can convert it?
is this needed ?
init-connect=SET NAMES binary