public class MyH2Dialect extends H2Dialect {
public MyH2Dialect() {
super();
registerFunction(
"normalize",
new SQLFunctionTemplate(
StandardBasicTypes.STRING,
"REGEXP_REPLACE( "
+ " REPLACE( "
+ " TRANSLATE( "
+ " LOWER(?1), "
+ " 'áàãâäéèêëíìîïóòõôöúùûüç', "
+ " 'aaaaaeeeeiiiiooooouuuuc' "
+ " ), "
+ " ' ', "
+ " '' "
+ " ), "
+ " '[\\u2000-\\u206F\\u2E00-\\u2E7F\\\\''!\"#$%&()*+,\\-.\\/:;<=>?@\\[\\]^_`{|}~]', " + " '' "
+ ")"
)
);
}
}