[1.2.4] Case insensitive JPA order by

[Spencer Strombotne]

I've got a "person" JPA object that has a name string. I'm trying to retrieve the people from the database in order by their name. The problem is that some of the people have names that are all lowercase so they always appear at the end of the results. I've tried this:

List<Person> people = Person.find("order by UPPER(name)").fetch();

.. but it doesn't work. It orders all people by name but someone with a lowercase first letter ('adam') still appears after Z 

Anyone have any ideas?

[loict]

it seems it depends on JPA implementation. 

for instance with hibernate lower should work : http://stackoverflow.com/questions/9934494/jpa-perform-case-insensitive-order-by

what's yours?

[Spencer Strombotne]

I'm trying the following:

List<Person> people = Person.find("order by LOWER(name)").fetch();

It's returning the same as if I had just done:

List<Person> people = Person.find("order by name").fetch();

So a* still appears after Z*

I'm using the default JPA layer that is packaged with 1.2.4, so hibernate I think.

[Spencer Strombotne]

This was my mistake. The data was being sorted again further down the stack that I was unaware of.