case « Search « JPA Q&A





1. MYSQL case sensitive search (using hibernate) for utf8    stackoverflow.com

I have Login Table that have utf8 charset and utf8 collation when I want check user name and retrieve other information for this specific user name the hql query give me ...

2. Hibernate + Postgresql with case insensitive searching    stackoverflow.com

I've been googling around for a straight-forward solution on getting our new postgresql + hibernate setup working with case insensitive search, without luck. We had previously been using mysql which has ...

3. Case insensitive search in hibernate without criteria    stackoverflow.com

I want to do case insensitive search in hibernate Query. I can do it with Criteria but it is not an option for me right now. The method which fire query ...

4. Case insensitive searches, DBAs recommend nixing Hibernate!    forum.hibernate.org

Hibernate version: 3.0.2 Name and version of the database you are using:DB2 v7 OK, so the bottom line, per a previous thread I posted is that Criteria based queries with Expression.ilike on VARCHAR fields that hold values greater than 255 characters in DB2 v7 tank out because the LOWER() function used to perform the case insensitive searching fails due to: SQL0171N ...

5. case insansetive search    forum.hibernate.org

Hello. Hibernate 2.1.8 DBMS: InterBase 6.0 :( I try to get object by its string property in case-insensitive maner; Query query = session.createQuery("from UserGroup ug where UPPER(ug.groupname) = :searchString"); List list = query.setString("searchString", "admin".toUpperCase() ).list(); But this don't work, i don't understand why. Any suggestions? IB 6.0 does not have 'lower' function, so i refused Criteria.ilike

6. Any way to force case sensitive searches?    forum.hibernate.org

I have an HQL query that works pretty well, it gets what I have requested it to find ... However, The code which Hibernate is replacing performed case sensitive searches of the database; that is, If I have "Fred" stored in the databse and guery for "fred" it would not find that. It would only find "Fred" if I queried for ...

7. case sensitive search in Hibernate 3 ?    forum.hibernate.org

8. Implementing OracleDialect for case-insensitive search    forum.hibernate.org

We need to support consistent search behavior of our applications across different DB systems. Generally search for objects by String fields in search pattern is expected to work like this: customerId customerName 1 test 2 Test Search for customer by customer.name = 'test' should return 1 AND 2 as results in all cases. This is a problem on Oracle case sensitive ...