I have a problem with ORDER BY clause. I have a simple query:
select u from User u order by u.name
When the name starts with "normal/english" character, records are ordered correctly. But when it starts with language specific character like 'Č', these records are placed after records with normal charaters. So records with 'Č' are after 'Z', but this is not correct, because 'Č' is between 'C' and 'D'.
Is there any way, how to sort the records correctly?