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 4:26 PM, Thomas <[email protected]> wrote: > Using SET COLLATION is only possible once. However, my JAVA-application > allows the suer to chage the language at runtime. So i do not know how to > get the results appropriate to the current language in select * order by > statements. > > A way aorund could be to create order colums. However, updating these > columns for every data change is expansive. Furthermore itt cannot be done > using a trigger. > > Is there a way to change the result order depending on the current locale > in JAVA ? > > select * from a where ... order by (JAVA 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.
