#1422 [HHQ-1995] MySQL by default is not case sensitive

[Hyperic Team]

http://jira.hyperic.com/browse/HHQ-1995
MySQL by default is not case sensitive ->

mysql> select * from EAM_SERVER_TYPE where name = 'sendmail 8.x';


+-------+-------------+--------------+--------------+------+-----------------+---------------+---------------+----------+----------+


| ID | VERSION_COL | NAME | SORT_NAME | CID | DESCRIPTION | CTIME | MTIME | PLUGIN | FVIRTUAL |


+-------+-------------+--------------+--------------+------+-----------------+---------------+---------------+----------+----------+


| 10302 | 0 | Sendmail 8.x | SENDMAIL 8.X | NULL | Sendmail Server | 1208387896174 | 1208387896174 | sendmail | |


+-------+-------------+--------------+--------------+------+-----------------+---------------+---------------+----------+----------+


1 row in set (0.00 sec)

I do not believe Hibernate has a way to change this on a per table basis when hbm2ddl is executed.

I found a server option to fix this issue.

collation_server=utf8_bin

Unfortunately for this to work I believe the DB needs to be recreated completely to take affect. I experimented with alter table and it won't work with pre-existing tables.

We need to test an upgrade path for this. Perhaps dumping and restoring the db is an option.

I will update the docs if this works.