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 (*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.
