Hello. The default sort order when database collation wasn't specified or was specified as OFF is LUTZ, JOSEF LUTZ, JOSEF ANTON LUTZ, JOSEFA because this is how java.lang.String.compareTo() works.
If database collation was specified, for example, as EN, the sort order is LUTZ, JOSEF LUTZ, JOSEFA LUTZ, JOSEF ANTON because this is how collators (java.text.Collator) work and strength setting doesn't affect this order. H2 doesn't provide possibility to add own rules to collators, so this behavior cannot be currently changed. H2 also supports collators from third-party ICU4J library, but I never used it and I don't know how these collators work. Don't try to use CHAR / CHARACTER / etc. for variable-length strings, these data types can only create additional problems, they are suitable only for fixed-length strings. -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to h2-database+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/h2-database/693e066f-fd9c-40a6-b325-3620bdc34c77n%40googlegroups.com.