CODEWITHSUNDEEP
javaspringoracle-databasehibernatequerydsl
fhgomes_ti
fhgomes_ti

Reputation: 195

QueryDSL with ignore accents

How can I use Java QueryDsl and ignore accents in Oracle?
With HQL I can use translate function.

"upper(translate({alias}." + field + ",'âàãáÁÂÀÃéêÉÊíÍóôõÓÔÕüúÜÚÇç','AAAAAAAAEEEEIIOOOOOOUUUUCC')) like (?)";

Upvotes: 1

Views: 1453

Answers (1)

Timo Westkämper
Timo Westkämper

Reputation: 22200

You can use the same in Querydsl using

Expressions.stringTemplate("upper(translate({0}, 'âàãáÁÂÀÃéêÉÊíÍóôõÓÔÕüúÜÚÇç', 'AAAAAAAAEEEEIIOOOOOOUUUUCC'))")

Upvotes: 3

Related Questions