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...
3 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?💤 Post marked as dormant
This post has been inactive for over 300 minutes, thus, it has been archived.
If your question was not answered yet, feel free to re-open this post or create a new one.
In case your post is not getting any attention, you can try to use /help ping.
Warning: abusing this will result in moderative actions taken against you.