[hibernate-issues] [Hibernate-JIRA] Commented: (HHH-3701) SQL function "trim" is not available in Sybase Dialect

[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-3701?page=c... ] Steve Ebersole commented on HHH-3701: ------------------------------------- I've gone ahead and committed the function changes needed to support trim on sybase into trunk, 3.3 and 3.2. Gail, when you are done refactoring the Sybase dialects there is a one-line change you will need to make to have those dialects use this properly. For trim function registration you'll need a line like this: registerFunction( "trim", new AnsiTrimEmulationFunction( AnsiTrimEmulationFunction.LTRIM, AnsiTrimEmulationFunction.RTRIM, "str_replace" ) ); the current sybase dialect has: registerFunction( "trim", new SQLFunctionTemplate( Hibernate.STRING, "ltrim(rtrim(?1))") ); -- 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