How can I use Java QueryDsl and ignore accents in Oracle?
With HQL I can use translate function.
"upper(translate({alias}." + field + ",'âàãáÁÂÀÃéêÉÊíÍóôõÓÔÕüúÜÚÇç','AAAAAAAAEEEEIIOOOOOOUUUUCC')) like (?)";
How can I use Java QueryDsl and ignore accents in Oracle?
With HQL I can use translate function.
"upper(translate({alias}." + field + ",'âàãáÁÂÀÃéêÉÊíÍóôõÓÔÕüúÜÚÇç','AAAAAAAAEEEEIIOOOOOOUUUUCC')) like (?)";
Copyright © 2021 Jogjafile Inc.
You can use the same in Querydsl using