Bug #4526 building with utf8_bin collation causes help to be case sensitive
Submitted: 12 Jul 2004 22:00 Modified: 27 Aug 2004 18:21
Reporter: Erik Kay Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Installing Severity:S3 (Non-critical)
Version:4.1.3 OS:Linux (RedHat ES 3)
Assigned to: Alexander Barkov CPU Architecture:Any

[12 Jul 2004 22:00] Erik Kay
Description:
We compiled and installed 4.1.3 with a default collation of utf8_bin.   It appears that mysql_install_db doesn't override this collation to utf8_general_ci.  As a result, the various "help <keyword>" statements are now all case-sensitive.  One place where this sticks out is the message you get when you get when nothing you typed matches the help tables.  It says: 
   Please try to run 'help contents' for list of all accessible topics
And given that the category is actually "Contents" not "contents", even that command doesn't match.

How to repeat:
(1) Compile with the options: --with-charset=utf8 --with-collation=utf8_bin
(2) Install
(3) run mysql_install_db
(4) type "help select" or "help contents" from the mysql command prompt

Suggested fix:
mysql_install_db should enforce its own charset and collation as appropriate
[30 Jul 2004 13:42] Alan Burlison
If you use the uppercase version of the help topic, e.g. 'STATUS' instead of 'status', the help does work.  From looking at the various help_* tables in the mysql database, all the keywords etc are uppercase, which explains why this happens.
[27 Aug 2004 18:21] Alexander Barkov
Thank you for your bug report. This issue has been committed to our
source repository of that product and will be incorporated into the
next release.

If necessary, you can access the source repository and build the latest
available version, including the bugfix, yourself. More information 
about accessing the source trees is available at
    http://www.mysql.com/doc/en/Installing_source_tree.html