FULLTEXT search does not honor case sensitive _bin collations

drop database if exists `MatchQueryTest`;

create database `MatchQueryTest`;

use `MatchQueryTest`;

CREATE TABLE `Herb` (

    `Id` int NOT NULL AUTO_INCREMENT,

    `Name` varchar(255) character set latin1 collate latin1_bin NULL,

    CONSTRAINT `PK_Herb` PRIMARY KEY (`Id`)

);

INSERT INTO `Herb` (`Id`, `Name`)

VALUES (1, 'First Herb Name 1');

CREATE FULLTEXT INDEX `IX_Herb_Name` ON `Herb` (`Name`);

SELECT COUNT(*)

FROM `Herb` AS `h`

WHERE MATCH (`h`.`Name`) AGAINST ('First*' IN BOOLEAN MODE);