Hi, I suggest to create a new database with a different collation, and then migrate the data.
> a) Permit connection to a database even if the collation is different and can not be updated That wouldn't work properly. Indexes are sorted depending on the collation, so queries wouldn't return the correct result. > b) Add a feature that enables H2 to update the collation This would mean "automatic migration". This doesn't need to be done inside the database engine itself. I think it can be done purely on top of the database, using the existing features "script" and "runscript". Regards, Thomas On Wednesday, May 11, 2016, David Weisgerber <[email protected]> wrote: > Hi, > yesterday I had to face the problems with sort ordering of Umlauten in an > H2 database. For this I had to change the collation of the database which > is only possible before the tables of the database are created. So I had to > specify the collation in the connection string (I am using JPA/Hibernate). > However this implies some problems for me when updating my product because > as far as I see the program won't startup if the connection URL specifies > the wrong collation. So I have two feature requests: > > a) Permit connection to a database even if the collation is different and > can not be updated > b) Add a feature that enables H2 to update the collation. This is > specifically useful for web applications where you want to change language > settings after Hibernate has already started. > > Thanks, > David > > -- > 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] > <javascript:_e(%7B%7D,'cvml','h2-database%[email protected]');> > . > To post to this group, send email to [email protected] > <javascript:_e(%7B%7D,'cvml','[email protected]');>. > Visit this group at https://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 https://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
