Need help with Hibernate for handling citext datatype
Im using citext type column in database. When I fetch it using JPA methods say findbyname(name), it casts the name to varchar and performs normal text comparison.
Citext is used for case insensitive matching hence when I hit query in db, Google=GooGlE returns result, but via JPA it does not.
Exactly the below issue. Please help
https://github.com/vladmihalcea/hypersistence-utils/issues/743
GitHub
Allow PostgreSQLCITextType entity attributes to be used in the LIKE...
Spring Boot 3.3.3 (hibernate 6.5.2). PostgreSQL 14.2, hypersistence-utils 3.8.2. SELECT e FROM SomeEntity AS e WHERE s.textField LIKE :search @Entity @Table(name = "table_name") // ... So...
2 Replies
⌛ This post has been reserved for your question.
Hey @Huskycoder! Please useTIP: Narrow down your issue to simple and precise questions to maximize the chance that others will reply in here./closeor theClose Postbutton above when your problem is solved. Please remember to follow the help guidelines. This post will be automatically marked as dormant after 300 minutes of inactivity.
What exactly is
name?