Hi, is any way for write HQL query which is diacritic insensitive? I can write native SQL, but it is only for one database (Oracle for example - upper(convert(column_name, 'US7ASCII')) like upper('%pattern%')). In HQL propably it isn`t such way without some additional function. Could I write some function which can be used during generation SLQ from HQL and there substitute for some own tag. Then I have one function per database type. And this function can be configurable. Could do something like this?
|