I dumped my mysql variables and these are the differences that I noted: 1) I am using utf8 for my character sets:
| character_set_client | utf8 | character_set_connection | utf8 | character_set_database | utf8 | character_set_filesystem | binary | character_set_results | utf8 | character_set_server | utf8 | character_set_system | utf8 | collation_connection | utf8_general_ci | collation_database | utf8_general_ci | collation_server | utf8_general_ci This might have an effect on the sorting algorithm, and could be the cause of the problem you are seeing. 2) Various buffer sizes are different, but this probably just reflects differences in memory sizes. 3) You changed the port to 3307 4) Your sql-mode is set to nothing, while mine is: | sql_mode | STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION Not sure if this could cause the problem. View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4132948#4132948 Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4132948 _______________________________________________ jboss-user mailing list jboss-user@lists.jboss.org https://lists.jboss.org/mailman/listinfo/jboss-user
