Re: bzr commit into mysql-5.1-bugteam branch (Dmitry.Shulga:3498) Bug#36742

[Konstantin Osipov]

* Paul DuBois <paul.dubois@stripped> [10/10/05 19:43]:
> Question that stems from idle curiosity: Given that the user and host
> name parts of MySQL account names are not case sensitive, why does the
> mysql.user table define them using case-sensitive collations?
> 
>   `Host` char(60) COLLATE utf8_bin NOT NULL DEFAULT '',
>   `User` char(16) COLLATE utf8_bin NOT NULL DEFAULT '',

I don't know. But it won't be easy to change.


--