MySQLDialect should use 'character_length' Standard function for registry 'length' hql function ----------------------------------------------------------------------------------------------- Key: HHH-4025 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-4025 Project: Hibernate Core Issue Type: Bug Components: core Affects Versions: 3.3.2 Reporter: Michael Astreiko Priority: Critical Attachments: mysqlDialect.patch Currently MySQLDialect register 'length' hql function as 'length' Standard MySQL function. But MySql standard function 'length' ([http://dev.mysql.com/doc/refman/5.0/en/string-functions.html#function_length]) returns the length of the string, measured in bytes instead of length of the string, measured in characters. So there is a problem when MySql database use UTF-8 encoding and for some characters (such as German umlauts) used 2 bytes. So MySQLDialect should register 'length' hql function as 'char_length' Standard MySQL function ([http://dev.mysql.com/doc/refman/5.0/en/string-functions.html#function_cha...]) which returns the length of the string, measured in characters. Appropriate patch is attached. -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/hibernate/secure/Administrators.... - For more information on JIRA, see: http://www.atlassian.com/software/jira