Hi, > Using SET COLLATION is only possible once.
Yes. The reason is that the indexes are persisted (stored) in the database file, and changing the collation later on would mean all those indexes need to be re-created. > Is there a way to change the result order depending on the current locale in JAVA ? > select * from a where ... order by (*user function*); That's complicated, and the index could not be used. Regards, Thomas On Thu, May 1, 2014 at 3:49 PM, Thomas <[email protected]> wrote: > I use H2 in a JAVA-Application whicht allows the user to change the > language at runtime. > > So the sort order (collator) should also changed at runtime. However, that > is not possible currently. > > A way around could be to create order colums. However, updating these > columns for every data change is expansive. Furthermore itt cannot be done > using a trigger. > > So my question ist: can I create a SQL-Statement like: > > select * from a where ... order by (*user function*); > > > -- > 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 post to this group, send email to [email protected]. > Visit this group at http://groups.google.com/group/h2-database. > For more options, visit https://groups.google.com/d/optout. > -- 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 post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
