I recently upgraded to mysql-4.1.14-r1, and all my PHP applications started to display strange chars when displaying queries returned by mysql. I found that in mysql.eclass, was changed from latin1 to utf8. The problem is that PHP doesn't honors my.cnf and uses the default charset compiled in mysql. A way to change the default charset that mysql is compiled is needed.
You can complain upstream, it's their default value, nothing prevents you from setting a different one in my.cnf or per-databases or whatever. This is not a bug. File a new bug about php if you wish (though we are already aware of the issue).
But how can I change the default compiled language ? AFAIK, the only way is to change mysql.eclass
Same problems here, but i think it isn't a mysql or php bug. Some error: illegal mix of collations (latin1_swedish_ci,implicit) and (utf8_general_ci,coercible) for operation '=' ---8<-------- The 'my.cnf' is configured to latin1. On my Webpage they print '
Same problems here, but i think it isn't a mysql or php bug. Some error: illegal mix of collations (latin1_swedish_ci,implicit) and (utf8_general_ci,coercible) for operation '=' ---8<-------- The 'my.cnf' is configured to latin1. On my Webpage they print 'ä' as "ä" aso. Thats since i upgrade three packets on 11.04.2006 with the daily portage-tree. A downgrade to mysql-4.1.14 didn't change the situation.