2

I am trying to set the collation of a new H2 Database over an Android device, and I have two doubts:

If I don't specify the collation name of the database with collation is used for it.

Where I can find a list of the differents collations that exists and support H2?

Thanks in advance

1 Answers1

1

By default, String.compareTo is used (lexicographic ordering - see the the Android documentation for details).

You can use set the collator using set collation (see docs for details). One of the new Locale(...) constructors is used depending on how the collation is set. You would need to check what languages / countries / variants are supported in the Android documentation.

Reto Höhener
  • 5,419
  • 4
  • 39
  • 79
Thomas Mueller
  • 48,905
  • 14
  • 116
  • 132