Hi, just FYI: ICU4J seems to do what I want (COLLATION set to GERMAN). Just added it to the classpath.
Regards Helmut Helmut Leininger schrieb am Sonntag, 19. Juni 2022 um 08:50:42 UTC+2: > Thanks for the explanation > > Helmut > > Evgenij Ryazanov schrieb am Sonntag, 19. Juni 2022 um 03:05:29 UTC+2: > >> 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 [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/h2-database/bf0ba117-631c-4f9d-a2d0-2e6591e211d0n%40googlegroups.com.
