Hello Ivo On 2005-09-17 Ivo Danihelka wrote: > 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.
Did you read the manual? IIRC it is normal that user created tables keep their charset until you explicitly change it. mysql.user is a different thing as it's from the server itself. bye, -christian- -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]