Using the Hibernate 3 schema export tool does not work with MySQL 4.1.14 for our model because MySQL complains that:



Because a UTF-8 character is stored as three bytes in MySQL the maximum key length can only be 1024/3 characters long. The compound key in many of our tables seem to be violating this constraint.

Scowered and only came up with this: http://jira.atlassian.com/browse/CONF-2783

So, are the only options to:

1. Change the character encoding, or
2. Reduce size of varchar columns

Can someone with MySQL with SchemaUpdate verify that and describe what properties they are sending in their connection URL (using connectorJ)? I've played with the various driver URL options here http://dev.mysql.com/doc/connector/j/en/cj-configuration-properties.html

Also, is there a way specify the length on an ID field? Assume we are using UUID.HEX and I want the varchar to be of length 32, rather than the default it seems to be using for 255.

Thanks,
Roll

Mmm... okay. This appears to be a bug in MySQL:

http://bugs.mysql.com/bug.php?id=4541

There appears to be a number of workarounds below:

1) Adjust character set for columns to be latin1., or

2) Specify character set to be used by driver. Either by driver URL (still would like to hear of someone using ConnectorJ successfully here) or using the Hibernate connection properties.

eg. hibernate.connection.charSet=latin1

For option #1, can we somehow specify character sets on individual columns somehow in our mappings? I don't want latin1 for everything which I think option #2 implies.

Am I missing something?

Thanks,
Roll