Bug 130661 – mysql-4.1.14-r1 character set trouble

• Status: RESOLVED DUPLICATE of bug 129761
• Product: Gentoo Linux

[Description Patrik Karlsson 2006-04-20 14:15:28 UTC]

Hi,

I noticed a problem with my joomla installations once i upgraded to mysql 4.1.14-r1. All Swedish characters were replaced by jibberish. A downgrade to 4.1.14 (without changing any of the config) resolved the issue. The database tables are set to use the latin1 character set and relevant portions of the my.cnf file follow:

[mysql]
character-sets-dir=latin1
default-character-set=latin1

[mysqladmin]
character-sets-dir=latin1
default-character-set=latin1

[mysqlcheck]
character-sets-dir=latin1
default-character-set=latin1

[mysqldump]
character-sets-dir=latin1
default-character-set=latin1

[mysqlimport]
character-sets-dir=latin1
default-character-set=latin1

[mysqlshow]
character-sets-dir=latin1
default-character-set=latin1

[myisamchk]
character-sets-dir=latin1

[myisampack]
character-sets-dir=latin1

# use [safe_mysqld] with mysql-3
[mysqld_safe]
err-log                                         = /var/log/mysql/mysql.err

# add a section [mysqld-4.1] or [mysqld-5.0] for specific configurations.
[mysqld]
character-set-server            = latin1
default-character-set           = latin1

[Comment 1 Jakub Moc (RETIRED) 2006-04-20 14:22:06 UTC]

*** This bug has been marked as a duplicate of 129761 ***