Good evening lords and ladies.
I'm working with an SQLServer legacy database, it's fields are plenty of bad encoded characters and not so bad encoded characters. Like this: ZU#IGA ZU¦'IGA ZU¿IGA ZU=IGA ZU¥IGA ZUÃ?IGA ZUÂ¥IGA ZUðIGA ZUÑIGA
All surenames refer to Zuñiga surname, if I write a query changing the problematic characters by "_" underscore, the HQL query finds all possible fields related.
i.e.: Select surname from names where surname like 'Zu_niga%'
Question is: Exists an Hibernate mechanism to filter and replace the problematic charactes before a parameter substitution takes place or before query execution?
Thank you!
|