I've discovered that this behavior appears when I set default-character-set to utf-8. The setting is in /etc/mysql/my.cnf: [mysqld] default-character-set = utf8
It is interesting that this affect only some columns in mysql database. For example, column mysql.user.User stays at latin1_bin collation, but mysql.db.User gets utf8_bin. The changes are reversable, the column type reverts back to char(16) when I disable utf-8 as default-character-set. -- Ivo Danihelka -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
