Hi,

In MySql, columns are case insensitive by default. Case sensitive can be forced in following way, by adding BINARY keyword:

CREATE TABLE foo (ID int, Name VARCHAR(20) BINARY, Address VARCHAR(50));

My question is, how can I create case sensitive table columns, using SchemaExport, by add some attributes in the Hibernate mapping .hbm.xml file? I could not find any attribute to allow me to specify the column to be case sensitive.

I am using Hibernate 3.0, MySql 4.1, mysql-connector-java-3.1.8-bin.jar.

Please help, thank you!

Fan